I've never worked overnights, but I did work nights and weekends for a few years. I usually worked noon-9. Which wouldn't've been too bad, except that my two roommates - my best friends - worked completely opposite schedules (7am-4pm, and 4am-noon) so we pretty much never saw each other and were always yelling at somebody for making too much noise while somebody else was trying to sleep.
Anyway, I liked working noon-9, because I was a night owl and LOVED being able to sleep in in the morning. But what was really annoying was that when I got off work, all the stores were closed, nothing good was on TV, restaurants were serving the crappy food, and all my friends were getting ready to go to bed. I LOVED having two weekdays off - to be off while EVERYBODY is at work is really lovely - but I did hate working weekends. Especially Saturday nights.
Overall I'm happier now with a 9-5, Mon-Fri schedule, but there are definately perks to working off-schedules.