SQL Server 2008 and extended properties
Largely ignored, as you're saying.

Extended properties are a bit awkward to read and write both from T-SQL and GUI. IMHO documentation should be maintained elsewhere (database projects, project documentation etc.).

Here's a good article on extended properties, which also addresses some of your doubts.