Currently in Alberta, 20 some% of the population supports leaving canada and joining the states. I can see it raising over time if the federal government continues to 'dislike' us. In the late 80's it was something like 45% percent.
Personally, I'm undecided.
I would not be surprised if 20% of Texans wanted to join Mexico.