When I saw it the first time, I was confused. Probably because it had so many errors and plot-holes, I couldn't think straight. Second time around on DVD It grew on me some more. Apart from the holes and DELETED scenes (that would've MADE the movie far better!) it's not that bad. The Battles are also very sweet, and there was some nice moments - Those including the Wedding, the Planet Chase (as stupid as it was), the Romulans getting owned and Data saying "Goodbye" *sniff*
I also liked the look on Picards face when the Romulans showed up. Was a really tense moment, especially with the synth and ambient "engine" sound - Just something about that little moment that was dark, sadly they we're there to help

The possibily of another Trek movie is almost zero, but I think there is a new possibilty with Enterprise. Enterprise is set to finish before the Romulan Wars, after it's Seven-Year run (if It gets one). So unless it goes over seven years, a movie based in/around the Romulan Wars would be great, no? With the right kind of direction, writing, drama and specials - Would be like a B5 movie ;-)