>In short, the relative positioning of notes on the staff is good from a tonal perspective but crap from a finger perspective on most every instrument except piano.

That's not really a problem once you build the muscle memory, though.

It's the same thing as touch typing. With enough practice, you know that finger placement X will produce note y, the same way you know where the keys on the keyboard are.