I don't know too much about the other places.
Say what? I visited Durham recently and had a blast -- lots of cool local businesses (Fullsteam Brewery was an amazing find) and neat old warehouses and charming old houses and such. Carrboro was also great, people biking everywhere and local hippie markets and stuff.
https://www.citylab.com/transportation/2018/05/what-went-wro...
Sure you might find a couple good job opportunities in Nashville or Tampa, but its hard to compare that to being in the thick of tech industry where you're right in the middle of the world's top companies, surrounded by lots of talent to push you further.
I don't know what a real solution would cost, but it's a question worth asking IMO.