Just because this is on my mind - The ending to the Goblin starting quests in WoW.
I really wanted to love these quests. I really did. The premise behind each and every one was great, and it all seemed fun, until I was standing on a mount or floating with my feet frozen in the air. Blizzard, what the hell were you doing with the animations here? So many of them were just so bad! I got over that.
Then, in the final battle...what the hell. Seriously, these events and crap dialog made me think my character was going to wake up from a dream. It did not make any sort of sense.
At the end of the quests, you get on a boat, and head to the Orc capital. The boat doesn't leave on its own, you need to talk to one of the people on the boat to get it started. Now, I don't remember if the quest text told me which person to talk to, but I couldn't find them due to the boat being packed and her name not being highlighted. Took me forever to get a damn boat that should have just started on its own moving.