What is your oncall alarm or ringtone?
The typical one is the siren. I try to make mine less alarming and so I put on a comical low-toned "ghost" noise. They always become associated with bad times as incidents start to associate with the song.
How do people deal with this? Any sound(s) that work better for people?
Always on call because salaried Sysadmin, so mine is just my usual ringtone. Just don't choose anything you like, or you'll grow to hate it.
If you use PagerDuty your choices are limited.