The source engine has (almost) limitless capabilities, and If you need it to look better, they give you the source (to source shaders) so you can change and and new ones. The only real limitation to a mod is if you use SoftImage XSI Mod Tool, which limits exports to 4000 Poly's (7500 if they are in envelopes, but I don't know what that means).