I skipped the Joker Funhouse Coaster at SFOG last month. There was a queue. Looked like 30 min. Might've been 20.
Thing is, I've been kind of been spoiled with short waits on amazing rides, so for me I'd probably have a hard time waiting multiple hours for anything.
With a couple exceptions, I've never really had to wait that long for a coaster in my Top 10. The exceptions are one of my Lightning Rod waits where they paused to put a second train on, and the night ride on Beast (both took around an hour). I've done half hour waits for Millennium Force, but that's no problem, especially with three trains and a constantly moving queue. For the rest I've never had to wait longer than 20 minutes, and even most of my rides on those have been walk ons.
I've had a few other random hour+ waits over the years where they were kind of unavoidable, like Superman: The Ride when it had the abysmal VR, Valravn in it's opening year, Gringotts because it's so popular, and my first Batman: The Ride at Great Adventure when it had ****ing one train operations. I think the longest I've done is 90 minutes for Hulk in 2010, but that's when I didn't know any better.
I might be thinking too realistically here. There are a lot of rides that are definitely worth an hour wait (probably the Top 20). Although I'd rather avoid waiting an hour for anything. I'm not gonna wait an hour for Skyrush during the day when I know the queue will die down later. Though I'll gladly wait for another Beast night ride, as you can't get around the temporary firework closure.
I've never waited 2+ hours for anything, don't think I would. I haven't done Steel Vengeance, that's probably worth it, but then again I'd probably just get Fast Lane.