Well, I think it's different when you either die of natural causes doing something you absolutely love, or from unforseeable events and dying from a careless and easily avoidable action. If you totally love kayaking, then I would think that that would be a good way to go (albeit morbid thinking about it).
I have two good friends of mine whose fathers both died rowing. They absolutely loved the sport, dedicated many hours/days/months/years of their life in the sport and (fortunately?) died of natural causes, literally keeling over in the boat. But if they died from forgetting to put on a PFD, I don't think that would be the ideal way to die.
Just my $0.02...