In SC most people played the stock version 1.08, at least in my (only multiplayer) experience
V1.08 was very stable and practically bugs free.
But you can see what's available here:
http://www.subguru.com/downloads.html
at the bottom of the page.
Personally i have no experience with the SCX/SCU MOD.