Usually if i've been to a park a lot I have very little patience at all. Whereas if it's my first or second time visiting a park or on a ride i'm more than happy to wait for however long necessary to get on. I'm also a lot more willing to queue for longer if I have traveled a long way to get to a park.
My longest wait in recent memory was Taron. Waited best part of 2 hours for a front row ride on Taron a couple of weeks back. Worth every second in my opinion.
Unfortunately, as much as they enjoyed it, my non-enthusiast friends didn't think the queue was worth it and I had to wait till last ride of the day to convince them to jump back in line. Only waited 60 mins then.
I also can remember waiting around two hours for Cheeta Hunt, X2 and Harry Potter & The Forbidden Journey. But that was back when I was around 15-16 so the exact time is blurred a bit for me haha.
I really wish more parks did what Thorpe and Alton do with having an app that shows the latest queue times. As Thorpe is only a 30 minute drive for me, if I have a quiet Sunday or the park is open late i'll just check the times. If over half the coasters are less than a 20 minute wait then i'll go along for a couple of hours and see how many rides I can get on.
For example, this was one of the days I went too with their recent Love Island Lates that kept the park open till 10:00pm.