Having watched somebody die miserably over weeks in a hospital hooked up to machines and being treated like an object I think being drugged up is vastly preferable. There was almost no warmth or comfort in the process.
I remember watching a Canadian movie about a father dieing from cancer and the children buying him heroine. In the end they all got together and he overdosed and died in peace. Seems like a good way to go out out.
Obviously I don't know how I would really respond in that situation.