Microsoft has just launched a new site called Dot Net Stories. This has a collection of videos on how people have used the Dot Net Framework to build their applications.
You can filter the stories based on technologies such as SharePoint, Windows Server, Windows 7, Windows Azure and SQL Server.
The SharePoint section is a bit light on content right now. The good thing is that you can submit your own story and be in with a chance to win some great prizes, including a Galapogos Islands Adventure. Just promise me that you won't use a cheesey profile story in your submission. You'll know what I mean when you have a read of some of the current entries.