"Domain\User" vs "User" What's the difference if the user is local?

Well, in SharePoint land its a big difference. SharePoint will throw all kinds of weird errors if you forget to include a "domain\" prefix for a windows user when you create a "site collection" or web application.

The best practice is to alway use "domain\user" to avoid any confusion.