Ian--it sounds like your mind is made up although I don't understand why you can't just stay where you are since you home office. Wherever you end up, I am sure it will be a new adventure although you seem to like being in Scottsdale.

For years I was in Dallas/Plano twice a month and this is my take.
Pros: Inexpensive housing, great restaurants and bars and shopping, very nice people.
Cons: The weather (imo) is horrid. It's not horrid all year but when it is, it's bad. High humidity and torrential rains with flooding are a huge for me. It is very flat--I like more variety in my landscape. I was always getting lost as there was no point of reference--everything looked the same.