I've been blessed to have worked in a few for small periods.
Honestly, there is a lot of grind, though there are good times to make up for it. Lots of 1am finishes while your ears feel like they are bleeding trying to mix tracks down properly, deadlines looming, trying to keep recording sessions on schedule so the next booking can get in on time...etc. The money wasn't terrific either.
Some people think it is just headbopping and working with truly talented artists, but 75% of people who I worked with/for in the studios I was at either couldn't sing, or did music I just couldn't vibe to. Death metal was the worst.
There were a few decent rappers who I managed to source beats to, but it wasn't the fairytale I thought it would be. Be realistic about it and if you truly don't mind the grind and the bad parts, you will find that the good times really do make up for it.