I may be in the minority, but my favorite ST franchise was Enterprise. Trek fatigue is what killed what was a terribly underrated show.
Not to mention T'Pol in her Vulcan Cat Suit.
I'm with you.. Here is what I think killed Enterprise (Which I thought it was one of the better Trek shows):
1. Trek Fatigue
2. The Temporal Cold War. If time travel was the main storyline something is wrong.
3. It seemed that Berman wanted to bypass Kirk and Company and go straight to the TNG.
Season 4 was the best Trek ever..
Even though the show was cancelled, the last episode was horrible except for the ending:
http://www.youtube.com/watch?v=pXotJu1CapUI did like T'Pol, I also liked Hoshi as well..