Most of the time, no. Not every pump handle has a functioning hold-open mechanism, but the vast majority of them do.
> ...filling up the tank until it magically knows the tank is full?
It's not magic, it's simple application of physics. [0] I would be shocked if this wasn't a feature of every nozzle that was usable by members of the public... nozzles in the UK included. :)
[0] https://en.wikipedia.org/wiki/Fuel_dispenser#Automatic_cut-o...
It varies--based on state I believe. There's a little catch that can be used at some pumps to fill without holding onto the pump handle. It actually does shut off quite reliably when the gas reaches the nozzle. It uses a venturi mechanism. [1]
You're supposed to stay there and keep your eye on it but it's pretty reliable. Only once in my life have I seen this not work as it was supposed to.