>>2949891 (OP)
>fire hose style
More convenient "set and forget" valve control for longer consistent watering/spraying applications. Functionally similar to generic nozzle in middle otherwise. Less convenient for dynamic spray control or intermittent (off/on cycling) spraying. Inconvenience can be mitigated if you get one that has a "thumb" lever on the back of the handle rather than the huge d-handle pictured (unlike an actual fire hose nozzle you won't need a big D-handle for extra grip and control on garden hose pressure) since the thumb type is pretty much the best of both words.
>generic sprayer
Baseline. Can adjust the travel of the "trigger" and lock it in place for extended use like the fire hose one but it's more fiddling around and less convenient and as mentioned low quality ones are prone to leaking. Squeeze trigger is more convenient for flow adjustment in situations where you'll be rapidly changing flow rate and especially when stopping and starting flow a lot (read: watering plants without hosing down everything between them too).
>brass nozzle
Trades convenience for size and simplicity. Thread nozzle up or down to change the spray from a high pressure line up to a wide misting fan to closed off, all at full flow/pressure unless you supplement with an adjustable valve behind it on the hose. Main benefit is the robust construction and the narrow profile/overall size that lets you snake it into drains/downspouts/etc to break up dirt and debris, or even use to cut and evacuate dirt in spots that are difficult to fit a shovel or trowel.
