I work in entertainment, in LA, and the day-to-day reality is nothing like what I imagined when I started my career (and I don't like the city). If I'm being honest I spent too long falling victim to the Sunk Costs Fallacy.
https://thedecisionlab.com/biases/the-sunk-cost-fallacy/
So I've started to think about this the other way around. I want to live somewhere 1 hour from a major city, 1 hour from a national park, with all 4 seasons, with a job market that has lots of interesting opportunities. My career will simply be secondary to that.