What's even the point of issuing rulings that can be ignored by the collusion of two out of 27 members?
No it isn't. Some 30% of decisions are made unanimously in scotus, and this is hardly an outlier. Requiring unanimous consent makes things way slower, yes, but it doesn't prevent them. Not all organizational changes need to be controversial. Several conservative programming languages did well by requiring unanimity in initial years - only adding what all could agree was good. It only requires those members to exercise good judgement.
Once you start looking for tenuous connections, every human activity can be subsumed under trade. It's a wildcard.
On the other hand, EU states retain their national sovereignty, and could leave the EU if they disagreed with the EU that deeply, which the UK has currently done. The ability for states to group together and buck rulings, in a sense, makes it less likely for states to leave the union entirely. This ability may also have helped convince states to join the EU in the first place.