It's a lot more complicated than most people think.
For example, a racing bicycle works best when the tires are as light as possible, which minimizes the gyroscopic effect.
Please see the website below to learn about the factors that affect bicycle balance, and why the gyroscopic effect is not a major factor.