I always thought that QNH with ApproacH and QFE with TowEr was the best compromise.
I was instructing at a UAS when we changed from QFE to QNH. Not too difficult until one (very good) student was given an EFATO. She called that she was above the turnback min height and started a turnback only to have the QFI take control and climb away. Brought up on QFE she'd reverted to habit - only the aerodrome elevation was nearly 400 ft and she was much lower than she thought.
The QNH experiment didn't last that long - but it wasn't Learning Command who insisted we went back to QFE, it was the fast-jet pointy-heads.
Why does the RAF use QFE? For the same reason mutts lick their nuts - because they can!