Scott has a great post where he dispels the following two myths about using LINQ to SQL.
Looking at the post I think he also added in dispelling a third legend, though he didn't explicitly call it out.
Personally I have not used LINQ to SQL yet, though I do intend to play with it at some point. I know I have talked to many folks (including friends at Thoughtworks) and I have heard it far easier to grok and use than some other Entity frameworks :)
On the intuitiveness said, I am sold. It took me about five minutes of looking at sample code to understand how to use it.
Thanks for this post Scott!