Dr. Fissell had a memorable quote (summing up some of my more pessimistic thoughts):
We know that end stage renal disease treated with dialysis has worse mortality than metastatic colon cancer. If somebody gives you a choice between cancer and renal failure, pick the cancer.
You can find the video by searching on "The Kidney Project: Live Q&A" (in quotes or not). He says this at 37:23.
Note that the immunosuppression drugs used after a transplant can increase chances of some cancers, so I guess the choice isn't completely hypothetical.