It all depends on what we mean by "hybrid." If it means going into the office to use Zoom, then no thank you. Remote is draining but convenient, in-person collaboration is energizing but inconvenient. Hybrid done wrong is the worst of both worlds.
I find in person to be draining, so the opposite of you.
I guess this is the core of the difficulty. Not everyone feels the same but very often we’re forced into someone else's ideal.
I agree with your main point - hybrid isn’t great when it is too prescriptive. Works well enough if each team is given the flexibility and latitude to decide what works best.