It's good and bad.

I worked on rotating shifts on a helpdesk. 2 weeks out of 8 was 7pm - 7am shift.

The good was that the office which normally had about 100 agents during the day was reduced to 3 or less. Way quieter and you could do/wear/say anything without issue. During day shift I'd be answering around 10 calls per hour but at night if be lucky to answer 1 per hour.

This is also one of the negatives. Not having much work to do or other people to distract you would make the 12 hours slow to a crawl. Missing out on daylight sucked. I was always tired because 2 weeks is not long enough for the body to adjust.

For the right job and the right pay I would consider night shift again but overall I'd preferably avoid it.