Not always.
There is no CoM 'sweet spot'. Bikes with low COM (at or below the axles) increases steering input resistance, and reduces sensitivity. Great when riding a Harley or GoldWing at speed while touring, but becomes a frustrating handful when navigating city street at 25mph.
Dirt bikes, at the other extreme, typically position the CoM much higher, which reduces steering input resistance, increases steering sensitivity and makes balancing easier. Preferred attributes at lower speeds and switchback trails.