If you were on your death bed it'd be a pretty attractive prospect, but in the end it'd be unfulfilling. All of your experiences would occur in set parameters, you couldn't really accomplish anything or leave any lasting impact on anything.
My feeling about Inner Light is that through the experience, his neural activity didn't really change, and his experience was compartmentalized. So when he came to, even though he felt like he'd gone through a lifetime, the same thoughts were fresh in his head.
When I go on vacation to a place I haven't been in years, I remember things I did last time I was there like it just happened. Memory responds to cues very well.