The last episode of Enterprise was the biggest disappointment. They unnecessarily killed off a main character, and then the "big momentous event" happens off-screen and in two seconds.
After that you find out that the entire episode was just being watched by Riker and Troi on the Holodeck, as a pathetic excuse for a cameo.