Besides NWN series, Elder Scrolls games, Gothic series (especially Gothic 3) -- there's been some other games that have really benefited from its mod community, too.
Also, I must say -- Vampire: Bloodlines and Arcanum were other games (all from Troika) that really benefited from having the mod community basically take it over.
I really hope Torchlight's mod community is going to be something, given how powerful that toolset looks in the previews for those who want to mod/make some action-RPG type of stuff.
And yes -- I'd really liked to see Larian support a SDK. That'd rock -- and if they do plan to release a SDK, the community decides to embrace it.