The Content Query Web Part is great!

If only Microsoft could create everything like this!

Metacode!

Just like Microsoft Office.

I would single out in particular;

• Enterprise Blogging
• Enterprise Wikis

in SharePoint! Not as good!

This idea talks about the importance of tools - although I would interpret this to mean not just for developers (e.g. Visual Studio) but also power users - and users!
https://en.wikipedia.org/wiki/The_Mythical_Man-Month#Specialized_tools

So I think Microsoft should stick to designing the Core!