Question: I'm looking mainly at things like new SQL syntax, new kinds of locking, new capabilities etc. Not so much in the surrounding services like data warehousing and reports...

Answer: 
Filestream blob storage is the biggest bonus to me
HotAdd CPU. <http://msdn.microsoft.com/en-us/library/bb964703.aspx>