I've got Sperzels on a strat and Grover's on a LP. Both work and sound just fine.
I'm sure you could find many people that could debate the merits, tone, and sustain of vintage style bushing tuners compared to modern tuners or locking tuners.
In the real world, on stage, through a high gain amp are you really going to notice a slight decrease in sustain if there was one? Probably not. Neither will the audience. They will however notice if you are out of tune.
If you change strings as often as I do, locking tuners are a big time saver too. Watch with the Grovers though, as they make some different sizes and if you get the full size ones and you have mini's on your guitar already, you could wind up with a neck diving guitar. I've noticed that on my LP. I went with the larger ones for 'more mass and sustain'. Didn't notice any but did notice the new neck diving characteristics my guitar took on. I went back to the smaller ones. Didn't notice any change in sustain either so there ya go.