Happy medium, definitely.
I have a 5yo (and DC2 on the way). I want him to know that he is loved & wanted & valued for who he is, no matter what. I want him to know that he is incredibly important to me. I want him to know that other people, including me, matter too; I want him to know that he won't always get what he wants, and that that's fine and ok and part of life.
I want him to know that mostly I make the decisions because I'm the adult, but that sometimes I will give him a choice. I want him to know that I empathise with him when he can't get what he wants, but also that throwing a hissy fit doesn't make me change my mind. I want him to know that I am reliable and consistent and do what I say - if I say I'm going out without him then I am, if I say I'll pick him up before lunchtime the next day then I will. I want him to know that sometimes it's his turn to choose the cafe and sometimes it's mine. I want him to know that I love his company but that sometimes I want to be just by myself, or with a friend.
I think these things are almost universal, though. I think virtually all parents agree that children need good boundaries, empathy from their caregivers, acknowledgement, love, practice at not getting what they want. I tend to assume that the examples people observe of other parents falling short of this tend to be poor judgment calls by tired parents trying to do their best, or sometimes by people using a shorthand to explain their actions (e.g. "I'm prioritising my kids right now" covering a multitude of reasons for not pursuing romantic relationships, which is a really personal and emotive topic and not one id necessarily expect people to be honest about, even with themselves).
I grew up knowing full well I wasn't my mother's priority. The lesson I learned was that people who love us can be distant and unreliable, and that it's best to do everything for yourself, to a ridiculous extreme. I wince a bit when I read some of the tough-love-teach-em-young posts on here. If we want to err one way or the other, I think it's probably much easier for an older child or adult to learn they're not the centre of the universe after all, than it is to learn that they matter.