yes and no. Mathematically speaking, the higher the better because the closer to infinite it is. The instrument input is nothing else than a voltmeter in fact.
In real life though, the quality of the component and circuitry will add, or not, subtleties which will make the input sounding good, or not. That's why DI sound better, and different, although on paper they could have the same specs. Also, 10 Mohm is not necessarily better than 1Mohm, the ratio is already so high, only a tiny M of input is sucked. The circuitry and quality is more important than the numbers. All instruments inputs are designed as instrument input, the ears and reviews are the only judges of the quality of the result.