Yes, not at all uncommon in the BDSM community. Neither are 24/7 kink relationships. However, reality is different from fantasy and there is a fair amount of nuance in how this works in the context of a LTR and not a fun weekend.

yeah I've known subs with a "I want to wake up in the middle of sex" or "I want to be drugged" fetish.

Yeah, some people are into that. Terms called free-use. Sometimes its just an overly desire to be available to your significant other but there are many different ways one arrives at such affirmations

Many people like a bit of subordination/domination. As most things, it's a spectrum and there are some people tending to either edges.

The two big caveats about subordination fetishes are however that firstly, such fantasies can be a response to trauma and/or abuse and secondly, it puts you in a very vulnerable position and leaves you very open to exploitation.

It's the "comfy wholesome" part which really holds this together and makes it great: You're putting an immense amount of trust and responsibility on your partner if you submit yourself like that and it can only work if your partner is fully aware of this, up to the task and really cares about you.