It may not be "long" in terms of hours, however I'm not looking forward to my 2.5hr flight on an ERJ145 going from ORD-ALB

Another horrible flight is a rather short one, UIN-STL. It is only a 30 minute flight, however you are practically riding a crop duster that is noisy and uncomfortable.