The day we went to Banff it was cloudy and rainy. The Gondola is very expensive for just a ride up the mountain ($34.95 for adults) The view is breathtaking, but I would advise not to waste your money on a very cloudy day... take in the hot springs pool instead and relax... if it's not crowded that is :)
