
That’s a super fun concept. Warhammer 40k does something similar with the emporer of mankind, who is either dead or nearly dead and on life support for thousands of years. I feel like it’s less known now but in the Hitchhiker’s Guide books there is a part that talks about the emporer of the galaxy who was placed in a stasis field during his dying moments. I haven’t ever actually tried to look it up but always wondered if one was a nod to the other.
This is touching on the really inflexible damage system in DND. My games tend to have real hospitals/clinics for dealing with the wounded and sick in a way that can’t really be expressed with the DND hit point system. This is fine for my games though, usually this kind of medical care is addressed through roleplay and outside of combat. NPCs often get wounded in a way where a healing potion or spell will only stabilize and will not make whole.