Since Kirk had such a terrible death, lets think up the worst possible deaths for the other captains.

Picard always talked his way out of everything so him dying in a fist fight with a giant unnamed monster seems perfect.

Sisko would always make the hard decisions so him dying of allergies sounds good.

Janeway the hopeful always believing that she would get home dying of transporter malfunction would be like poetry.

Archer the explorer dies from warping into a star. Approved by Rick Berman.