Hello everyone,
I don't know if this was posted before, but when I had an SMF community I was always looking forward the latest mods, I don't if this isn't the case anymore but in that moment the Mod Site didn't showed the latest approved mods which is different to the latest mods since some mods could take a lot of time in the approval queue which means that they won't be shown in the later list.
In order to track the approved mods, I simply tracked the new topics created in the Mods Board, to do it all you need to do is to follow this news feed:
https://www.simplemachines.org/community/index.php?action=.xml;sa=news;board=59;limit=10
Hopefully it's still useful and could be used by someone :)