Here you can find custom downloads for your Sims on The Sims 3. Most of the downloads are free and some sites may require that you join/sign up to download their custom content. This list of sites will become larger once I dig some more. For the ones that’s not in English, you can always use Google Translator to translate the sites.
I’ve decided to list site for The Sims and The Sims 2.