worth moving for a promotion..?

I have never been to Houston or Colorado so I can't give my opinion on which is better/nicer. My question is, how do you know you wouldn't be happy in Houston ?