Right. I want to play an a perfect human. An idealized version of a person.
I want to forget about my limitations in a video game.
Not fetishize them.
It's fucking weird.
And like you said if the story needs it then that's fine.
Example, in Devil may cry 4/5 when the character's arm is ripped off.