I've found mainly three major limitation of SharePoint 2010.
I will arrange them in three manor:
1. Simple :
SharePoint 2010 does not support .NET Framework 4.0
2. Average :
SharePoint Designer 2010 does not support looping.
3. Complex :
Excel services can not connect to SharePoint Data.
Thanks & Have Fun!!