sincere question: are you MRM?
It's a good job if you make tenure. But most people fail and it's incredibly sad. I got lucky and made it, but, along the way, saw plenty of deserving and hard working people fail. Moving is not a big deal, if you don't have family. But, if you have young kids, a working partner, it becomes hard - and I saw many people "fall far" because they did not want to move - and end up taking some adjunct position or move to a community college, just to avoid moving. Seeing someone who spend 10 years working 12-16 hour days trying to make tenure eventually fail is soul-crushing, if you have any empathy. And "failure" is hard to define - but I am talking about someone who worked hard to become a researcher and end up in a position that is mainly teaching/service.
It's also sad to lose friends. By the time I made tenure, all the people I had made friends with had been fired. At first you don't notice, because you are selfishly obsessed with your own career path. But once that is secure, you realize how the turnover around you affects you.
Finally, the unfairness is also depressing. There is luck, and that is a huge component. Some papers don't deserve to be published at top journals. But, among those that do deserve publication, some get lucky in the referee-drawing game, and some don't. There is also nepotism/favoritism at play, which adds frustration. But I think the noise in the process is more damaging overall.
Am I happy with my life choice? Yes, because I worked hard AND got lucky and now live a great life - well paid, flexible hours, spent my days thinking about topics I genuinely care about.
Yet, when students ask me "should I go for a PhD?" I hesitate. The risk is too great, to be frank. There are few professions in which you can be smart, work hard, and still fail. This is one of them.
Around 50-60, based on ASU ranks. 3-0 school with “3As and something else” expectations.