You'll note on that video the guy mentions the weird stuff happens if he doesn't go right to bed when he takes it. Not going right to bed is likely the largest factor in the weird episodes people have. I've never waited more than 5 minutes to go to bed after taking a hypnotic, and I've never had a problem. Though on the other hand my dad also didn't stay up after taking it and still ended up washing all his pills, so it just varies.
But yeah as you live alone and haven't ever taken it before, going with one of the OTC options is the best idea. I've found the doxylamine actually works better for me as far as keeping me asleep than the prescription hypnotics. Main downside for me is the doxylamine gives me a bit of a "hangover" for a couple hours after I wake up.
As I can't afford that during the work week, I use Sonata most often if I take anything. It wears off much more quickly than Ambien, which can lead to having trouble staying asleep later in the night, but it also gives me no hangover. I don't know if it has the same blackout-and-do-weird-stuff risk as Ambien or not. But if I know I'll have time to sleep-in or otherwise deal with a bit of post-wakeup sleepiness, I go with the doxylamine.