Thinking of a Never Failing Alarm Clock

Why not just disable the snooze button?
Open the clock, tape over the contacts that allow snooze to occur.

Or get a persistent cat - they always seem to want to go out when the sun rises.

Or move the clock farther from your bed so you have to get up to turn it off.
I find an alarm that beeps like a construction truck backing up is really obnoxious.