How come I've missed this? I don't know, but I'm writing this blog post so to bookmark this site.
You'll find a handful of scripts, mainly using Dynamic Management Views and Functions, to monitor various aspects of SQL Server.
http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true