Here's a VM rightsize / problem check report you could create today -
Base pack / infrastructure report template, use VM Object.
Add at least the following columns (names may not be exact): name, tot mem, runtime info max mem usage, no of vcpus, runtime info max cpu usage, partition name, partition free space.
Sort and group how you need. Maybe even use Business View to run against specific VMs
Use expression criteria to set parameters for partition free space - free space <= 10 (for example)
Unfortunately there is no easy way to directly compare max mem and cpu usage to VM's config via a single report, but you could use 2 different reports to compare the results manually.