I have two opinions on this.
First, if we were to join the states, I'd be fine with that. Main issues would be the medical system changing and potential electoral fuckery within Calgary & Edmonton (they've been voting conservative federally, but locally they have a liberal mindset festering within)
For separation, also fine with it but if it is to be sustainable, I personally feel Saskatchewan and Manitoba would have to come along. Saskatchewan has more farmland than Alberta for a stable income and food supply. Manitoba would give access to Hudson's Bay and in turn the Atlantic Ocean. I wouldn't mind the Eastern half of BC joining too as that gives additional income through forestry & vineyards, as well lock in the Rocky Mountains. It would likely cause a metric fuckton of strife for the territories as they would be completely separated from Eastern Canada by land and would cause a shitstorm of shipping issues along the BC coast (do you go through the states, do you go through the new country that hates you, or does Canada develop a road through the territories and make a port?), but that would become Ottawa's problem.