I hesitate to include this under tourist trap, but I found this turnoff about as exciting as watching paint dry. Certainly the Canadian Pacific Railway engineers (the ones who designed construction routes, not the guys who drove the locomotives) must be given great accolades for figuring out a safe way to get a train down the western slope of Kicking Horse Pass. The route curves and spirals over itself inside the mountain. Therefore, if a train is long enough, it criss-crosses under itself while descending the pass. This place fascinated the tourbus set, but I did not have the patience to wait to see a train pull off the criss-cross and soon set off in search of mountains, falls and bears. (It reminded me of being on the Danube River and watching the old-timers get excited about the river locks.
Make sure you take the time to read the interpretative signs along the overlook. Parks Canada does a very nice job putting up interesting and informative signage at various roadside turnoffs and hiking trails. The complete history of the spiral tunnels is presented at the viewpoint over the course of a dozen or so signboards.