We absolutely loved our stay in Canmore and especially liked staying at the Windtower Lodge! The suite was clean, comfortable (especially the bed), large and convenient.
Having a full kitchen and a free buffet breakfast was so nice, it definitely saved us money on eating out.
The location is also perfect. You can easily walk to downtown Canmore, although after a day of hiking we always decided on the 2 minute drive instead. It's also only 20 minutes or so to Banff, and we actually preferred staying in Canmore instead. Canmore seemed less crowded and touristy than Banff did, but with the convenience of being close by.
Windtower Lodge also had a very friendly and helpful staff.