This will probably be heresy so up front I will apologise to Gail,

but,

what I did was select the proc stats from dm_exec_procedure_stats and order by total logical reads descending.

THEN

Copy and paste into EXCEL.

THEN

Select all objects from DB which have TEXT from sys comments containing the table of my most needed index.

Copy paste into EXCEL.

THEN

Do a vlookup from the procstats and see which procs from your top 10 ( which exist in the syscomment query) are hitting the tables from the missing indexes with the biggest benefit index.

I know that I can create an almighty view to do this but it becomes cumbersome and unreadable, so this is a bit manual but quick and easy for me.

Shouldn't take more than 3 minutes.