The best you can do is look at specific carriers, and more importantly specifically what aircraft you'll be flying on.
A cross country flight in economy is going to be more comfortable in a Delta A220 than a United 737 Max. However, because of hubs and lack of competition many non-mega metros don't really have a large amount of choice.
ULCCs thrive when they can maximize their time in the sky across as many different flights as possible. Filling up the day with many different flights allows them to rake in checked-baggage fees, reserved seat fees etc more often than longer mainline carrier flights. All of this went out the window when a large portion of their A320 fleet was grounded because of the P&W engine issues. This absolutely killed their utilization percentage.
Spirit died way more because of business management than it did because customers didn't choose on price.
Im not sure how accurate this is, so willing to be shown differently!
My expectations are low and yet airlines somehow manage to fail. I made the mistake of booking a flight with frontier and they "delayed" the flight several times before eventually canceling the whole flight.
I am a current airline pilot, and I end up flying on all of them in order to get to and from work. Trust me, they all do this. The impact to you may be less if it’s an airline with more flights, because that airline has more options to recover and fix your experience, but they all do it.