Only been to Orlando once. Like everywhere it has pros and cons. I have to imagine all the tourism keeps a pretty decent local economy. Although it’s a bit of a drive, I’m a big fan of Florida beaches, especially on the Gulf. The water is just so warm and blue there.
The big downside to Orlando is it really is built on a swamp. It gets ridiculously humid in the summer and the mosquitos can be a real pain. The lack of mosquitos is part of what sold me on San Diego, coming from Minneapolis where the mosquito is sometimes called the state bird.
Also my understanding is outside of tourist season Orlando can be a sleepy town, for better or worse.