I wish I had the awesome experiences similar to what people have listed on here.
An experience which 'magical' seems inappropriate however I was very fortunate and privileged to witness was my dad's passing.
He had a terminal illness, was well cared for and after diagnosis never went back to hospital, his pain was well managed and with the support of district nurses he was cared for at home.
We knew he was going to die in the next few hours, days seemed too optimistic, and he was sleeping soundly in the bed in the room.
My siblings were sleeping in the floor, it was my turn to sit with dad, and as I turned away to reach my drink, he passed away. No coughing, struggling or gasping.
But, the most amazing part was the look of serenity in his face, he was turned to face a space in the room and had the most beatific smile, not a loss of tension in muscle but genuine smile, and to this day I believe his mum, my amazing grandma, had come to collect him to rest.
If people could have such a kind and comforting passing it would be a blessing.