I for one do not want my database to be exciting, I just want it to work.  That said, there are all kinds of new stuff in the SQL 2008 ecosystem geared towards devs, namely the Entity Framework.

I love the 08 T-SQL enhancements like CTEs, windowing functions, pivoting, better xml support, new data types, and geometry constructs.  Although the geometry constructs feel rather half baked.

So, from my perspective, you're talking utter tosh.