It definitely makes it a bit more playable. Even simple mods like speeding up loading in ME2 were great (loading times were tied to the loading videos, so even if it was ready it didn't 'load' until the movie was done ). Lots of mods to clean up textures, and some gameplay ones like prickly mentioned to remove hacking, surveyin etc.I honestly never knew it had mods to be honest, that's sort of cool, when I'll get back to the ME Trilogy...who knows though.
Wait, what mods are or were there for Mass Effect 3?
Well good to hear my memory isn't broken on that one but that certainly makes me hope they fix the 3440x1440 support. It's a challenging enough resolution on its own. I don't need another 3-5% penalty!
The best mod for all three right now I would say is ALOT. They have an installer and everything, works really well. I just recently did a new playthrough of all 3 and used ALOT on all of them. That said, you need to install all of your other mods first, so any of the gameplay, UI, fix mods all get installed first then you run ALOT and it deals with the textures. It's actually fairly simple and much better than it was before where you would have to load textures every time you started the game and it would take like 10-15 minutes each time.You can also install the ME3 textures in to ME1/ME2. Although it was by far the hardest install setup of a mod I've done.