It looks like some decent scripts have been shared. I would caution against msforeachdb or msforeachtable due to some quirks that can cause databases or tables to be skipped when they are used.

You can get quite a bit more table size information from this script http://bit.ly/tablespace. Only thing needed would be to add an appropriate cursor to cycle through each database and produce the results for all databases.