I think for me, the main frustration is the way those games are structured. You run around for a few minutes and when you finally have decent equipment, someone shoots you out of nowhere and you get kicked out, have to requeue and start over again.
On the other hand, when I die in Overwatch, Valorant, Counter Strike, Quake, Unreal Tournament (yes, I'm old...) I know that I'll be back in the action in a few seconds, I didn't lose much progress and I can still win this.
Check out Isonzo. It's a WWI trench warfare game that is PvP (some games may have bots). But it's objective based on offensive and defensive. You respawn really quick. It's not like arena since it's generally one shot kills and you're further away but it's a lot of fun.
Well I did have to spend minutes gathering armor or grabbing the wanted weapon sometimes in Quake II CTF or Quake 3. But yeah at least when you die you just respawn, no requeue.