I actually found DS9 straight out bad, and the series that came after Voyager was so bad that I have actively blocked its name from memory.
Kirk and crew really were the best, and I rate Next Generation and Voyager roughly the same. No, scratch that. There were no main characters I actively despised in Voyager, whereas Next Generation...Will ******* Wheaton.
To make it worse, Wheaton has gone on to be a nerd/dork/geek/sci-fi/etc spokesman/idol of sorts, which is like twisting the dagger after we've already been stabbed.
As for the new movies...sure, some perfect movie would be fantastic, but if I had to choose between the special effects J.J. Abrams version of Star Trek, or some Star Trek movie that was in the vein of where the franchise had been going for the last 10 years, I'd choose J.J.'s vision in a heartbeat.