This was our first visit to Banff and I had assumed that the campground would be along the lines of what you seen in many US National parks with so-so campsites, scarce and not that clean bathrooms etc...
We were really pleasantly surprised to find clean, well maintained campsites (we were in a tent) easy access to bathrooms which were not only clean but also had hot showers. I had made our reservation online through the Parks Canada website so check in was a breeze.
Would agree with some others comments about noise. The area we were in had lots of 5th wheels and it seemed like all of them were constantly running generators which would have been a bigger deal had we not been so tired from hiking all day. In any case the park rangers came around to remind people of quiet hours every night.
Location wise it's good, easy access to downtown Banff and the highway.