Compartmentalization like this also allows some influence to spread more than it would in a unified information space. It's possible for a larger country to convince a smaller one to side with them on an EU level issue, while "paying" for it on a national level.
I think that because of these barriers it makes sense that a lot of European voters feel entirely disconnected from EU level politics. It's preteen met with an attitude of "Brussels decided that we must jump, so we jump." It's reminiscent of the Soviet times with "Moscow decided". (Not in the decisions itself, but people's attitudes.)
The EU has a population of 450 million. 35% of it is a little over 157 million. Germany + France have a population of 149 million.
In practice every qualified majority vote has to have either Germany or France supporting the measure to pass the Council.
There are also Council votes that require unanimity. This is the so-called 'veto' that every country has. In that case obviously any country could hold up the process.
So, there are definitely places where things can be held up by a minority of countries, but I don't know if they can push things through. I think it would be more likely that they would leverage national level power for that.