Waterfowl Lake was our top choice in Banff. No hoookups. Heavily wooded. Camp along a little river leading down to Waterfowl Lake. Kayak down the river to the Lake (5 - 10 minutes). Very scenic lake.
We were pleasantly surprised by the "tent" camping section of the Lake Louise campground. Thought it was going to be like Yellowstone or Yosemite with crowds, but it was OK.
Just north over the border into Jasper was a little jewel called Wilcox Creek. Hiking the nearby trails was amoung the most memorable of my life.
YOu can't loose in the Canadian Rockies. Say as long as you can.