6 hours at SFOG the first year the Mindbender opened. We waited in line for 4 hours to get our hand stamped and then another two hours until it came time for our ride. The line was all the way from the Mindbender to the dolphin tank (diving tank now).
Longest for a working coaster.. i once waited 4 1/2 hours for M Force... but i waited 14.5 hours in line (very front of the line) for TTD.... It was wild.. got in line right away in the morning and did not leave the hole day... never did get on it that day.. but i did the next day.. there are some people on this site that stude in line with me...
Only time I've ever waited more than an Hour for a ride that I can recall was a little under 2hrs for the first time(first season) I rode Batwing. One Train op on a friday. Even Superman was only maybe 40min. I don't wait for hours for rides, I go during the week and get there early to ride the more popular rides.
Right at 2 1/2 for a front seat ride on MF. I have waited in many hour lines for ride such as GhostRider, Xcelerator, Magnum, Mean Streak, Superman Ultmate Flight, Goliath and X. But 2 1/2 is my longest, anything longer is simply not worth it IMO.
Believe it or not, I think my longest wait ever was for Batman at SFGAm... two years ago. The line was over two hours long but I wanted to get that one trip in on the "original."
I did MF of one and a half hours opening year, Son of Beast for about the same, but it wasn't operating until the last ten minutes (I don't really count that, but I see that others have), just over an hour for Nemesis, Air, Medusa (SFMW), Kumba, Big Bad Wolf, whatever the hang-n-bang at SFNE is called (don't ask), Space Mountain (DL, DW) and Mr. Freeze. If the line is over an hour, I'll generally leave and come back to the ride at the very end of the day. Most parks have enough to keep me occupied that I don't visit them for only one ride, so if one queue is too long, I'll move on and return...
7 hours for Millennium Force. It broke down, but it was the one ride we HAD to get on, so we stook it out and ended up getting exit passes to come back when it was fixed. We got on the next morning.
13.5 hours for opening midnight showing of Star Wars Episode 1. It was worth the wait. Yes, the movie was disappointing, but the experience of being there all day with such an enthusiastic crowd was great!