With this latest release of the GEM Automation library, analysis of the SQL Server plan cache has been added. You can get the same information as the stored proc/view analysis (missing indices, conversion warnings, columns reference, etc.) plus some high level statistics per plan such as resource consumed and execution counts.
You can download the release here.
Merry Christmas! 😉