I lived in the rockies (canmore) for 4 years and know most of the good areas east of Squamish.
Skaha is ace, sport and trad, but will be boiling in July. We used to go at easter. Could climb in the shade.
Revelstoke (waterworld etc.) - nothing amazing but OK for a day or so.
Bugaboos are as awesome as everyone else has said. Long logging track drive-in (not suitable for a big rv but camper van OK) followed by a few hours walk-in. Easy to get a shut-down by a storm cycle so try to plan ahead for a stable weather period. The glacier approaches to the towers closest to the camping are piss (Snowpatch, Bugaboo), like alpine cragging on big walls. The approach over the col to the backside of Snowpatch Spire was fine when we did it but subject to change/rockfall/bergscrund/snow turning into hard boilerplate/long slide potential (depends how competent you both are).
South Howser Tower is more involved requiring a bivi or a long approach early doors.
If you're feeling very plush you can be the person who flies in.
Back of the Lake - good for a couple of days on a trip. Lovely setting, perfect quartzite unlike the rest of the chossies. July is prime season (gets cold up there spring and autumn). Air Voyage wall is well good, gently overhanging 50m.
Banff area - nothing stand-out but Guides Rock has a couple of OK 'trad' (few bolts on them) routes. Paperchase was decent, couple of others. I wouldn't go out of your way.
Canmore Area: some really good limestone sport crags around Canmore, all have longish uphill walk-ins (not Grassi Lakes, although it's decent enough for a quick convenient hit):
4 best sport crags around Canmore:
The Coliseum - AMAZING! 1 -1.5hr steep uphill walk-in. 50 - 70m hard 7s and 8s.
Acephale - never really did much here but it's really good. Hardcore
Bataan - another really good sport crag with a death march approach. Both this and Acephale are well worth a visit, both are pretty hardcore not much pottering.
Crag X: at the top of Cougar Canyon - 45min walk-in. Really good.
You won't find info on The Coliseum, Baatan, top end of Cougar Canyon (or much of Acephale) on ukc. But they're the best sport crags by far.
Cougar Canyon, Grassi Lakes, Carrot Creek, Barrier Mountain, East End of Rundle, Heart Creek., None are anything special, each has a few worthwhile routes (generally obvious from guidebook) but don't go out of your way.
Ha Ling Peak - 'the longest sport route in Canada': it's alright but nothing special. Bit chossy, bit average, but fun. Nice to top out and walk down.
Yamnuska - If cloggy was another pitch higher and 500m wider, and made of (often chossy) limestone. Really amazing to climb here, but it isn't top quality rock, routes, or anything. Just the sum of everything makes climbing on Yam special. Adventurous, you could clock yourself easily. But most of the popular routes have been pacified with bolts on belays and run-outs. CMC Wall, Snert's Big Adventure i remember were both good fun. Lots of others. 45min-1hr uphill walk-in (theme around Canmore)
The Ghost wilderness. Beautiful spot, great camp spots everywhere - just park up and pitch. Go! Can take a normal car but you may not get out again - I used to go in with a honda civic and a vw golf but I tend to push things more than many it seems. Possible to park at the top of 'the big hill' and walk from there but adds around hour or more depending where you're climbing (it's a huge area!)
Any of the good routes in the Ghost guide are worth doing but aim for the longest (you can go cragging anywhere). Again the actual climbing, rock etc. isn't anything like world-class, but the sum total of climbing in the Ghost adds up to a very special experience.
Jasper area - I wouldn't go out of your way. Lost Boyz crag worthwhile but not amazing.
Alpine rock - most of the Rockies is limestone and most of it is choss. There's a few Quartzite areas. I wouldn't go especially for alpine rock routes but the East Ridge of Temple is good (crampons/axe needed for summit). Some Quartzite ridges near Jasper. There's a good-looking big trad wall being developed near Golden, details on Alpinist website.
Accom in Canmore - if you want to escape the van the alpine club hut is nice and central to everything. There used to be a campsite in town (I bought a house there, sadly now sold), not sure if it's been fully developed now, was being developed when I was there.
Bears - Be aware in any of the areas around Canmore, Banff, Ghost, Yam. Perhaps consider a can of pepper spray. Make a lot of noise when hiking to crags and take notice of warning signs/local newpaper reports. Many of the bears are tagged and locations known, this can be checked on the goverenment website/local papers. Maulings happen every summer, it isn't 'that' unusual.
Went to Squamish twice, it rained both times and I bailed to Skaha but I just got unlucky. Would have loved to check out Horne Lake.
If you discover my secret Cloggy made of quartzite, my trad projects from 2008 are still closed
There's a bunch more info I could send if you want to know anything in particular.