Project M and DPSS for FireRed and Emerald are the ones I've made sure to hold onto. I've played various mods over the years for every platform I own, but I find that I mostly enjoy mods that just update, improve, or otherwise refine what's already there. Rarely do I like mods that add user created content.