Each time I have been asked to return the size of the databases for the systems I manage, I tend to use this query. It returns the size for all databases found in master.

USE master

go

exec sp_helpdb

Here is the relevant Microsoft Article on it.