Q: "How do I know which fields have lots of values, which ones have only a few values, and which ones are completely empty?"

A: A free new app from Qandor called Field Trip makes it pretty easy to create a report (see screenshot) that summarizes how many values are in each field on an object.  Pretty cool!