There was only one game that ever used QTE appropriately, and it was essentially the game that invented it. Yes, I'm talking about Shenmue, and Shenmue was a great game. The whole game was QTE, but it worked very well.
Now, all games use the "Surprise QTE!" during cutscenes or random moments. The first boulder in Resident Evil 4, as an example. These don't really bother me, but they don't add too much either. They do, in a way, add to the tension of the game, but it's an artificial tension.
You're not "more scared", you're just uncomfortable from there on out. Like the difference between being spooked and having a neck cramp for being nerved-up for no reason at all.
The random QTEs that we see in games now are actually not that different from sudden instant-death encounters. We've been getting killed instantly for decades, from crashing boulders, to monstrosities hanging out of ventilation ducts. The former is just a different way of doing it. Silly illusion really.