Glad you're coming our way! I joined the board here because you mentioned it on your website ...
For travelling SP's there seems to be a mix of locations. Downtown seems very common, but there's quite a few SP's that also stay at the Airport or South on Macleod Trail.
I don't recommend the MacLeod trail locations, they're a little 'skeevy' for lack of a better word, and one recently had some nasty bedbug issues and was cited for it.
Avoid any hotels listed as being in the Banff Trail area, as it's a higher-crime area, and often locations used for some shady dealings. Most of the hobbyists I know avoid the location like the plague.
I do look forward to seeing you!