If you don't like the auto hold, don't use it.
Most of the time I use the hand brake like a conventional one, only as a switch/ button rather than lever you pull up or down and engage.
When I am parked I engage it by pulling up and seeing the orange light, to pull away I turn it off by pressing it down. If I need the hand brake at a junction, I just pull the button up again as required.
Well documented on here, the only issue with the above is trying to reverse or manoeuvre without the seat belt on. You have to have a firm foot on the brake and turn the hold mechanism off, to proceed.
I drive other cars, one with a conventional handbrake, one with a fly off handbrake, another Lhd & the GTi.
I quite like the variety and don't have a problem with jumping between any of them.