It's not a "purely technocratic role", but it is not one, in the current state of the history of the European Council, of the views of different member states (large and small), and in the actual language of the Lisbon treaty, that admits of the big charismatic leader option (without risk of considerable problems to come).

As for your premiss "most people want to be ruled by people they can identify with and admire ("heroeise") and who make them feel proud to be part of something bigger than themselves", I am not sure that that is in fact the case in Europe today. And, even if it were, it's not just the EU that would be on the lookout for such rulers, is it?