Your experience was very rare. The great majority of NDE’s are very positive.
I read a book years ago by a doctor who studied NDEs and his assessment was that those who had hellish NDEs were very reluctant to discuss them with anyone, except a trusted doctor.
Yes, there are some others, but not many, most see the bright light and see their re,atives etc. There was no seeing anything where I went through - total darkness, heat (likely due to the fever I had), couldn’t breathe and felt like I was suffocatin - and ,ots of sounds that I couldn’t make out- frightening experience. At the end of it I got “sent” to the “outer dsrkness” where I felt a very weird feeling of not existing, BUT being conscious of being all alone- that i think was as frightening as what my mind “saw” in my imagination about hell.
I was 17 at the time- many decades later and I still see it as though it just happened.