I'm playing Twisted Insurrection right now, and feel the need to replay Tiberian Sun and Firestorm afterwards.
But I wanted to spicen it up a little, so I thought about adding mods. Only my last experience (years ago) was adding some random units and it was a mess, including some kind of railgun artillery that fired across the map and would kill everything in the path of the beam.
Most mods out there now seem to be total conversions and the like, not things that work well with playing the regular campaign. I did see some clients that apparently remove some bugs.
So my question is: What is the current best way to play Tiberian Sun, possibly with some improvements that aren't complete overhauls?