As i don't think stats had been changed, then
https://coh2db.com/stats/ should still work.
https://i.serealia.ca/files/coh2dps.html is more updated but doesn't list all elements.
You give 2 different scenarios (dmg + Aoe) and rank. Listing them based on dmg is simple but ranking them overall is harder as there are more variables (range, fuse, cost, unit using it, upgrade through vet, etc.)
With only dmg been consider i'll list different types of grenades (might get the grouping wrong in some case) affecting infantry
Blenderkorp (slowing down + dmg)
Stun grenades
Molotov/Fire grenade
Rear echelon Rifle grenade (upgrade, not sure about the bunker one)
Assault/Volley grenades
Comet Self crew grenade
Rifle Grenade Grenadier
SturmTiger grenade
Standard nade (Rifles, IS, Guards, etc.)
Comet/Churchill Grenade
Shock Nade
Bundle/Gammon bomb
Satchel/Heavy Gammon
Not sure if i miss anything.