It's a big hassle when you first upgrade or if you find yourself having to reinstall MacOS and are installing a lot of programs at once. In normal use day to day with the occasional security prompt when installing an application, it's less egregious.
Seriously though, I'm willing to put up with mildly inconvenient UI changes (that diminish over time) in exchange for a more secure operating system.