we did a trip in 2000 around quite a few of the BC and Alberta resorts. Lake Louise was the busiest of all the resorts, and along with Sunshine was the coldest (-24 degrees celcius). When I say busy, we never had to queue, we just saw other people when we were on the trails, and the base area was very busy, but that is easy to avoid. Because of the higher numbers the snow was more packed than other resorts, but then that can just depend what day you go. If you can stay away from the base area . The scenery is awesome, the terrain is huge, and the base lodge is pretty spectacular as far as log cabins go. Their prices are higher than other resorts but you get a lot of facilities for your money, it has to be paid for somehow, and if you are spending US dollars you probably think it is cheap.
Banff is a 40 minute drive away, and has more faicltiies than Lake Louise. if you don't want to venture out much at night, you could stay at Lake Louise and save time travelling each day.
Definitely worth a visit.