Large list throttling is definitely a good thing, but will take some getting used to. Steve Peschka has a nice writeup on some of the implications of list throttling.
Ted gave one of the better explanations of LINQ I’ve heard or seen, which I didn’t expect to get in a SharePoint class necessarily. It’s welcome though because the LINQ support in SP2010 is pretty handy.
MSDN has an article on how to see what CAML gets generated by the LINQ to SharePoint provider.