Ok, last one for a while. This time, pulling the stats relevant to a plan from the plan XML in the plan cache (thanks to trace flag 8666), then getting a little bit of stats update history via trace flag 2388.
I'm not particularly happy with performance; it took between 10 and 12 seconds to return a 12 row resultset 😥
But its good enough for the immediate troubleshooting needs.
Some sample output is below; note that the output is sorted by database, schema, table, and stats name. But the updates of any one stat are NOT sorted based on the date in [Updated]. I don't have the brainpower right now to figure out how to convert the [Updated] values to DATETIME to get them to sort properly. Maybe sometime soon 😏