I mean, that's a quest at it's core but a good game works it into a narrative and makes it blend. Ideally making all 6 steps anything but tedious. Ideally interesting and fun, but at all times avoiding tedious like the plague.

Best example I've seen is this: https://www.youtube.com/watch?v=K4ADco41g9s&ab_channel=Nathidraws

Two identical "perform quest for NPC"s, which is your step 4. Negotiate for a thing in a briefcase from somebody who probably will double cross you.

Which one is more tedious? Now combine a 4 minute run in a barren wasteland in your steps 1 and 6...

A few other things that Cyberpunk did, There are several ways to handle that mission, those several options can cause 3 major shifts in that faction. Which affect other missions later on, indeed any time you deal with the maelstrom gang.

Cyberpunk had a lot of flaws but, they're at least innovating. I've never been in a legit standoff like that in a game. It's always been in a static looping animation at 8 paces.