I never heard of a game company getting sued for user made mod's.
Worst that happened was with that Hot Coffee mod like said before here. And it just caused the game to get rated as an adult game. And that wasn't user created, it was already in the game, tough you needed to hack the game.
IMHO, even higher ratings wasn't necessary, if you intentionally mess with your game, then don't cry if you see naked pixels smile