I have worked over nights, 12am - 8am. That was in my younger days (late teens and then again in mid 20s). It wasn't all that bad. But as my kids got older, day shift was much better for me. I have been working normal 8-4:30 day shift for 14.5 years now. I don't think there's any way I could ever go back to a night shift now. My body clock is just too used to day hours. I know this because even on my days off I still get up around 7am.
You can't buy happiness. But you can buy beer. And that's pretty much the same thing.