Love my Waterstone . I love having a latched on sprayer.

We didn't have a sprayer until we got our Blancomax 440703
faucet.
We absolutely love it.

Love my Moen Arbor single handle pull-down with Reflex, their effective self-reseating mechanism. The Classic Stainless finish is spot resistant. It has a spray hold button, and you can switch between spray and stream with just a touch of the button. It has a pause button. If it's on spray, when you turn the water off, it automatically reverts to stream so you won't get a surprise the next time you turn it on.

Here's a recent post about spray hold feature, and people talk about their faucets.

Here is a link that might be useful: Do I need spray hold?

Quite happy with my Whitehaus Metrohaus. It has a spray-hold button as Ginny described.