Yes, basically every eng position paying what HN people expect will have the exact sort of described oncall.
I worked on OS frameworks at a FAANG and there was no on-call for anyone on the team.
The users of your flawless frameworks absorbed all on-call load.
I have yet to be on an oncall that is similar to what was described there, and I get paid pretty well. It's very much a function of where you work and what you work on.