There's been plenty of reaction out there to Microsoft's sneak peek released a couple of weeks ago. I'm not going to add to the obvious if you haven't seen it then check it out here.
I was particularly excited by the demo which showed the creation of create, read, update and delete functions for a SharePoint list connected to an SQL database. Would really like to see how efficient that is.
Something I noticed in the background when the demo was being run was an option in SharePoint Designer 2010 to create a 'Re-useable Workflow'. The lack of porting workflows between lists is a major reason given not to use SharePoint Designer for this type of task. This seems to suggest that the next version will get round that. Again code efficiency will be a paramount concern along with the usual one of giving some power users even more ways to break the site.
In conjunction with this new functionality I also noticed that in the Visual Studio 2010 project lists was an option to import a Reusable Workflow from SharePoint Designer. Again it'll be cool to see how well this is implemented, if most of a workflow can be developed in Designer and only the complex areas need C# (or other) then this could greatly speed up workflow development.