Your PRO Ultra Heavy-Duty Metal
Your PRO Ultra Heavy-Duty Metal Front Trigger 9-Pattern Hose Nozzle (RP-FTPH) is the best one I've ever found (I have a box full of old ones).
Front trigger so it doesn't spray when put down, and it doesn't soak your shoes when on or off. Multipattern is great. Four patterns would even be enough. Jet, stream, mist are the most important ones in that order.
Problem was, I'm in Toronto Canada. Bought my first one years ago, don't recall where. Lowes maybe? Can't buy them here now, so it cost me 3 times more than the price of the three RP-FTPH hose nozzles in shipping and duty. Any chance you'll have a Canadian dealer?
My neighbors and I joke now when one of us is using a hose. "Is that a regular hose nozzle, or is that a Ray Padulla!?"