I did the low cost thing for 5 years, found a lucky break and managed to fly with a real airline again.
It depends on the nightstop location, the type of pub you're in and how much rest you have. Some places I loathe for one or more of the same reasons, and others I kill for.
Overall though a few overnights per month is much better than being at home every night.