That’s good. Vetoes were preventing too much things in the past. This should push member states to compromise and find agreements with each other.
While that may be true, I feel like you’re ignoring the fact that a foundational change to the core procedures that the EU operates by could absolutely drive more than a few member states to bail - and I’m not talking about Hungary or Poland.
Whenever you come across a “sword” solution to a Gordian knot of a situation like this, it’s crucial to consider how you’d feel if the shoe was on the other foot. This is, in fact, one of the core points of a democratic, rules-based system of government - the rules must be applied agnostically. If you’re making a rule that only “works” when you/your party are in power, it’s an objectively bad rule, and will be used in ways that you are guaranteed to not like.