Hi John
When are you coming? You are welcome to park at our place in Calgary on your way if you wish. Only on-street parking but we can run out power and water.
Opinions on Banff vary depending on preferences. It is quite commercial and can get crowded but has several attractions including the Banff Springs Hotel, many shops, and good restaurants including Georgios (italian), Grizzly House (fondue) and Bumpers or the Keg for beef. Nearby Lake Minnewanka is a pretty spot and you can rent an aluminum boat with an outboard reasonably for fishing or cruising on the lake.
Tunnel Mountain is close to the action in Banff but does not have sites as wooded or private as we like. The non-serviced sites are nicer if you can do without the ammenities.
If you don't want too much time in Banff itself I would recommend Kananaskis Country and Peter Lougheed Parks. Boulton Creek
(click here) is a gorgeous boondocking site and Mt Kidd
(click here) if you want all of the luxuries: hookups, tennis. hot tubs etc. These 2 areas are between Calgary and Banff but South of the highway.
Jasper is about 3 hours North of Banff and on the way you can see Lake Louise (photo below) and other turquoise wonders, wildlife and a roadside glacier. Jasper is as beautiful as banff area but less commercialized.
Currently $1 u.s. = $1.60 cdn
Meals and rv sites are about the same price as in the U.S. but in Canadian dollars so you end up ahead. Fuel is probably slightly higher here even after exchange. If you buy many items in Canada you can apply for a refund on sales tax 7%
Let me know if you have any other questions.