I was there in late summer six or seven years ago. Lots of wonderful hiking, glaciers, and gorgeous lakes. Then hit the hot springs at the end of the day. Also a fine golf course there, but I didn't get to play it.
I happened to be there during their music festival, and it made the visit that much more fun (afro-cubanismo jazz that year).
Plan to drive on north and spend some time in Jasper--a littler more wild and rugged, with elk grazing in people's yards in the evening. On the way, stop in at Lake Louise and spend a few hours exploring. Also, a ride up on top of the Columbia glacier is pretty amazing.
I signed up for a couple of raft trips up there, as well. Neither was particularly challenging, but it was a wonderful way to enjoy some spectacular scenery.
If you're an outdoors type, it's well worth doing!
JP