Found this recently posted video on SharePoint in Plain English:

It’s worth a look.  We are also in the process of building a common craft style video and I’ll post it here soon.  The benefits of these types of videos are that they clear away the hype and showcase the technology in laymen’s terms.  No need to think too hard.