I’ve had different height adjust forks in the past (Marz ETA, RS U-Turn, DT Swiss LC) and although they all worked, i.e. they lowered the front end, and reduced bounce when climbing out the saddle, it was a bit of a faff reaching down to flick a lever while trying to prepare yourself for the sharp uphill.
However, I’m now running what I think is the perfect solution – DT Swiss Twin Shot with remote lever. Now even if I’m already out the saddle sprinting up a hill, I just push a small lever with my thumb and the front lowers by 45mm and stiffens up (not locked out, still allows a bit of give). Same again to revert back to full travel. In short, it’s excellent.
So my advice is, definitely go for a fork with ‘climb’ mode, but only if you can get a bar mounted remote to control it – which severely limits your choice unfortunately, but worth considering.