Mixed bag in my opinion.
The good: No traffic, get to know yourself better since you have a lot of time for reflection, discover way more media (podcasts, books, games, movies) because you're always doing the night owl thing, always have an excuse to get out of social events during the day time, easy to go to doctor appointments during the day before work, feels like you have a ton of free time, usually meet interesting people on the night shift (see bad part of this below), get to dress down, don't have to see a high level boss usually, things feel more profound late at night - you'll have a much deeper appreciation for all that media I described (try some music or an audiobook at night - better yet, try writing. I always feel things deeper at night), get to see the moon all the time which I absolutely love more than anything, etc.
The bad: sleep schedule will be like being a teenager again, there will be days where the sun is shining and you can hear lawnmowers which will make you sleep like garbage, you'll probably eat like shit, seeing friends and family is hard, friends and family will not understand that you need to sleep during the day - trust me, you'll meet the outcasts of society on night shift along with all those interesting people I mentioned and some of them will be weird or off-putting, you'll feel super lonely at times but it'll be kind of nice somehow (???), you'll have too much time alone with your thoughts, you'll be doing shit during the day but have work hanging over your head for hours whereas normal people work and have free time after work to look forward to, driving home tired in the early morning is like having a hangover somehow, etc.
Personally, I'm glad I'm not doing it these days. After COVID, stores aren't open 24/7 anymore. Night shopping on days off was the best and not being able to get stuff at night now sucks.