Biohazard 4 was a complete restructure of the design in the franchise in favor of the western market which Capcom were experimenting in their other IP's like Onimusha: Demon Siege, the archetype of the modern third person shooter genre with literally no backtracking, puzzles or item scavenging. Its inevitable for escort missions to not be featured as the whole plot revolves around the character to be escorted out of the island. It isn't "FUCK THIS SHIT" level but annoying ? Maybe. The previous games like Zero, 1, REmake, Nemesis, CVX etc had these moments too but were more closed and involved backtracking, less BOW's and procuring items.
Call of Duty 2 on veteran. The 4th or 5th level. Never touched it again. Oddly, I enjoyed COD4, WaW and MW2 on veteran though.
CoD campaigns on veteran has always been pushing forward for the next available checkpoint with bullets getting sprayed on your character's hitbox from all sides of the screen. Its been the defacto design since the first game till now. There are very rare instances where you "have" to take the enemy out to proceed to the next checkpoint.
Mile High Club was a pain in the ass.
Its also fun

I legitimately had more fun in MHC veteran than the scripted All Ghillied Up and one of the very rare missions where you have to shoot to proceed.
The first Gears of War, on insane, General Raam, solo.
I must have fought him about 40 times with no luck. Each time, AI Dom decides to charge headlong into the boss and immediately die, offering absolutely no distraction for me to take shots without receiving massive damage.
I blame Dom. Fucking idiot.
I have vague memories since its been so long and I only used to play the campaign again after a tiresome session of MP to ease my mind. But I think it takes around 18 active shots from the longshot on his head or around 9-10 torque blasts to his head, both of them w/o the kryll protecting him. You can mixup as well. 9 longshot + 5-6 torques etc, again w/o the kryll protecting him.
About Dom, just have him go DBNO in the center of the platform and not on the 2 extreme opposite ends when your shuffling between both sides as RAAM gets closer to you.
There's also a glitch where RAAM gets stuck to those poles being stacked up horizontally (middle of the platform and left side of the screen after the cutscene is over and the end where Baird/Hoffman/Cole fire from the chopper's troika) and being exposed w/o Kryll for the entire battle but don't remember how, sorry.