I think Arthmoor and the team behind UFO4P have this licked already.
You go to that mod page and (here's the challenge for the masses) - read the mod description, you know EXACTLY where you stand. It's writ, clear and up front what the requirements are. Meet them, you're fine. Don't meet them, don't download the mod.
Where this falls down is, while any mod author can put this information out there, the majority of users can't/don't read mod requirements, install it blind, break their game, blame the mod author.
Until the masses start to read stuff that is there for their benefit, then no amount of metadata about a mod, the version of the game or anything else will matter, because at the end of the day, users are as dumb as rocks.