I had a similar issue with the Dramm redhead (1000 holes) in the UK. It was good, but not as good as it should be. My water pressure is decent, but for normal residential houses in the UK I don’t think the bore of the water pipe is as large as the US (or as large as UK nurseries, garden centres etc. can have). I tried the Dramm yellowhead (750 holes) too, but it wasn’t much different. I think it’s also down to the Dramm wand itself being larger bore so the pressure drops going from smaller to the larger pipe diameter before it hits the head.
I’ve found that the Kaneshine “Kyozen” to be the pinnacle of watering wands. It’s insane. 1261 holes (of 0.18 mm) in a tiny 22mm diameter mesh. Beautifully fine rain and a tiny head means small and agile to get between and under canopies.
But I missed the variable control of the Dramm wands! The Kyozen has a simple tapered copper pipe to push a hose onto. It was all extremely well crafted, so I did this with some guilt but I cut that off, cut down another brass fitting and brazed it on instead. Then I could use the Dramm OneTouch for precise thumb control. Best of both.
I use a Karcher pump with a remote to pump my collected rainwater to this wand. 4000lph and 4.7 bar so through the Kyozen it’s as good as mains pressure.
For watering can I use a Haws 4.5 litre long-reach metal can. I’ve tried various Japanese nozzle upgrades on it but I’ve found they all get blocked pretty easily since I only really use my watering can for organic ferts and additives.