Aside from having something terrible happen to my children, it would have to be a slow, lingering decline and death, including loss of faculties while being aware of loss of faculties and knowing exactly what sort of burden I am to others.
As for horrible diseases, ESRD is probably the one I fear most.
Thanks for the shudders this otherwise warm night.