Having watched a couple of cancer deaths from up close in the last couple of years I think that anybody that seriously advocates this has had limited exposure to the subject.
I can see the point of 'having time to come to terms with things' but if that time is spent in a morphine induced coma because you can no longer deal with the pain it is of limited value.
It's probably not the very worst way in which you could go but it definitely isn't the best.