As a prank
A water hose connected to a normal household tap can be used as an improved shower for purposes such as removing sand and mud before allowing entry to the house after playing at the beach or a muddy sports game.
For punishment/pretext of cleaning
This usage is typically found in prison scenarios where inmates are maltreated by the staff. Occasionally it is featured in BDSM stories and videos, where victims are typically naked and often also restrained or locked in a cage such that they can't evade the hard splash of cold water.
To intensify the punishment, higher water pressure and/or a sharper jet (e.g. via the nozzle) can be used. Fire hoses connected to special water sources will have a higher flow volume in as well as higher pressure and thus send a much more powerful jet. Another influencing factor is room (or outdoor) temperature.