Do you still need something for this? I am working on a script that can be ran continuously (sql agent job) that will monitor executing queries and analyze their execution plan and alert back if anything may need tuning.
I do, and I'd love to see a few variations of how to do this in separate articles, but if you have something that's focused on getting the queries that are problematic, that would be great.