So, speaking as someone whose focus as a player in RPGs is maximum immersion resonance with my character (speaking in particular to the segment of the game where resurrection isn't exactly on the table)...
I don't want to die, and I don't want to be numbed to death (that of myself or of a beloved party member.)
As a player outside of my character headspace, I do want some minor threat of death to enhance the Experience, but I want it very low. Like... Maybe 1-2% total cumulative chance (not chance per adventure or per level) from starting level up to the point resurrection becomes available.
Don't actually have 5E experience yet, from what I've heard it delivers on the minimal threat of death but does so in a manner that can be a little jarring? (Death save popcorning)
If run rules-as-written, D&D 5E is perfect for you. It is not, however, perfect for me.
Can you elaborate on where this is stated to be the Spirit of the Game?
Which version would you like?
AD&D Player's Handbook, c1978. "Swords & sorcery best describes what this game is all about, for those are the two key fantasy ingredients. ADVANCED DUNGEONS & DRAGONS is a fantasy game of role playing which relies upon the imagination of participants, for it is certainly make-believe, yet it is so interesting, so challenging, so mind-unleashing that it comes near reality...A good Dungeon Master will most certainly make each game a surpassing challenge for his or her players. Treasure and experience gained must be taken at great risk or by means of utmost cleverness only. If the game is not challenging, if advancement is too speedy, then it becomes staid and boring."
Moldvay Basic, c1981. "DUNGEONS & DRAGONS® Fantasy Adventure Game ("D&D® Game" for short) is a role playing adventure game for persons 10 years and older. In the D&D rules, individuals play the role of characters in a fantasy world where magic is real and heroes venture out on dangerous quests in search of fame and fortune. Characters gain experience by overcoming perils and recovering treasures. As characters gain experience, they grow in power and ability."
5E Player's Handbook, c2014. "In the DUNGEONS & DRAGONS game, each player creates an adventurer (also called a character) and teams up with other adventurers (played by friends). Working together, the group might explore a dark dungeon, a ruined city, a haunted castle, a lost temple deep in a jungle, or a lava-filled cavern beneath a mysterious mountain. The adventurers can solve puzzles, talk with other characters, battle fantastic monsters, and discover fabulous magic items and other treasure...There's no winning and losing in the DUNGEONS & DRAGONS game-at least, not the way those terms are usually understood. Together, the DM and the players create an exciting story of bold adventurers who confront deadly perils. Sometimes an adventurer might come to a grisly end, torn apart by ferocious monsters or done in by a nefarious villain. Even so, the other adventurers can search for powerful magic to revive their fallen comrade, or the player might choose to create a new character to carry on. The group might fail to complete an adventure successfully, but if everyone had a good time and created a memorable story, they all win."
So, yes, the spirit of D&D is high risk, high reward fantasy action-adventure, risking life and limb, etc.
I know personally I don't want High Risk.
In your post above you noted that you wanted no more than a 2% chance of character death until easy access to resurrection becomes available. Respectfully, that sounds like you don't want risk. You want your character to survive. Period.
That's so stressful, dancing on the edge of a knife makes for a great story, but a terrifying ulcer causing disaster of an experience if it keeps happening.
Right. You don't want risk. That's a perfectly valid way to play. It is, however, the opposite of what I want out of gaming.
Like, obviously I would forgive a GM who accidently gave us an encounter with bad (less than 90%) odds and no clear means to get out of it, but I would absolutely walk away from a game that was deliberately putting me on the tightropes.
I don't understand how you can think that having less than a 90% chance to win is "bad" odds. It's so high there's no point rolling dice. You just win. Huzzah. Conversely, I would walk away from any game that didn't involve risk. Nor would I run games for players who were that risk averse. It takes all kinds. Glad you have fun playing your way. It's definitely not for me though.