I don't think there is any reason to be concerned. When driving, the only higher spot with strongly winding road is the Columbia Icefield Road, past the Columbia Icefield stop (from Jasper towards Banff), and honestly, this is not a big deal.
There are a few spots, when you are getting close for example to canyons and waterfalls, where you have to be careful, but these are very obvious (I mean when hiking).
On the other hand, many popular spots are absolutely easy, not worse than the walk in downtown; like Lake Louise (nice, but IMO overrated).
I am just building the album from the shots I made in Mai. Some of it is up already, and there are quite a few panos; particularly the latter are useful for judging, where how the scenery is.
http://www.panopeeper.com/Rockies/RockyAlbum.htmhttp://www.panopeeper.com/panorama/Rockies.htmDo not miss one of the very best spots, Natural Bridge (but don't climb out on the rocks). Mistaya canyon and Marble canyon are musts (but so are many others).
I visited and photographed ("panoed") many other spots, if you have specific questions I may be able to answer some.