The Veritasium video is the best one I've seen but he only describes how counter steering works at slow speeds which is more like how you balance a stationary bike. The faster you go, and the bigger the wheel, the more the counter steering is done by gyroscopic motion than moving the wheel back and forth beneath you.
