Following a new European Union survey, Cardiff has been named the third best capital city in Europe, trumping some of the most celebrated cities in the world.