No official plans for mod support have been announced yet; the developer is just trying to see if the interest is out there. To me, and a lot of the people in the Maxis forums, it's very obvious that people are interested in being able to mod the game.
The types of user-generated content and mods under consideration will be ones that "do not jeopardize the integrity of the gameplay or harm the experience of others" and don't affect "the simulation for multiplay games." Basically, Maxis doesn't want to allow any game-changing mods, and instead only wants to allow cosmetic items.
Get more destructoid: We're indie-run, blogging for the love of it, and our site will always be free. Optionally, you can support us and get: (1) Faster pages from our cloud server (3) Wide(r)screen (3) No big ads on Dtoid, Japanator, Tomopop, or Flixist (4) Auto contest entries, and (5) Dibs on betas & downloads. Try it out
Unsavory comments? Please report harassment, spam, and hate speech to our moderators, and flag the user (we will ban users dishing bad karma). Can't see comments? Apps like Avast or browser extensions can cause it. You can fix it by adding *.disqus.com to your whitelists.