Conservative political commentator Rush Limbaugh was taking up to 30 oxycodone pills daily at the peak of his addiction 20 years ago, and it allegedly caused the hearing loss which forced him to temporarily retire. Now with terminal lung cancer, he's probably taking a higher dose now than he was back then. (What difference does it make when you're dying whether you're addicted to opioids or not?)
Limbaugh's example suggests it might be very difficult to go to sleep and not wake up with prescription pain pills alone. A potentiator might be required.
Polypharmacy is what can kill when it comes to prescription medications, not usually a single drug.
Historically, Marilyn Monroe died because her quack personal physician Hyman Engleberg prescribed her BOTH Nembutal AND chloral hydrate for sleep, and then perjured himself by lying all the rest of his long life in adamantly denying ever prescribing her chloral hydrate. (That was a ballsy thing to do, considering the fact the empty bottle of chloral hydrate with his name on the label was photographed on her bedside table, along with the fact of the hard copy of his handwritten prescription for that chloral hydrate never being back in his possession. In fact, Marilyn's psychiatrist Ralph Greenson should have been prescribing those medications if anybody was. Greenson died at age 68 in 1979, Engleberg at age 92 in 2005, so Engleberg's self serving bullshit side of the story prevailed for decades. That chloral hydrate prescription order sold at auction for $1,664.00 in 2011, and the hard copy image is online for everybody to see.) Nembutal alone might be enough to kill someone, chloral hydrate might be enough to kill someone, but in Hollywood's most famous drug OD death, it took two drugs, and neither of them was an opioid.
Where you are located can effect your access to the opportunity to go to sleep without waking up. There are some right to die states and nations that might avail you of physician assisted suicide or physician administered euthanasia.