Hmmm...summer, eh? Not 'crazy money'...? Could be a little tough, depending on your definition of crazy money...
Nicer places to consider: Emerald Lake Lodge, access right at Field, B.C., with a short-ish drive to the lake and the lodge. Very nice, canoe rentals & lovely walks, beautiful-looking accomodations, nice-looking restaurants.
Lake Louise has some nice places, too, but of course summer is peak season for accomodations. Post Hotel is an historic building, and there's always Chateau Lake Louise (but they're probably in the "crazy money" category).
Banff...? Lots of possibilities here. We drove up to Hidden Ridge Chalets and were very impressed by the views from a number of the units. This is on Tunnel Mountain Road - lots of other places there like Douglas Fir resort (waterslide!) and many more.
Canmore also will give you lots of choice and probably a little bit cheaper, but that's just on the other side of the Banff National Park (coming from Fairmont) so you might not like to go that far.
Any more specifics on your price range & such?
Bart