Is there a website or two that you guys use whenever looking for a mod for a game?
I've used Nexus before for Morrowind. I know Steam has mods for Civ. Seen a thread or two here lately for NWN/Baldur's Gate mods. Thought I saw one here very recently for a Titan Quest mod I think it was but can't find that thread now where someone said there was a great mod for it and the game shouldn't be played w/o it.

Been getting more into modding lately and so was just wondering if there's a one-stop shop type website out there for all the games that are mod-able in some way. Appreciate any constructive thoughts or comments that such a vague sounding question might bring here. Thanks.

http://www.moddb.com/

Yeah ModDB is the best one out there.
There's also the Neverwinter Vault for Neverwinter Nights and several smaller ones for very specific games, but mostly the ModDB is all you need.

Oh wow, hadn't come across that one before. Thanks a lot guys, I now know where I'll be hanging out the next couple of hours :).

ModDB is also linked with Desura, and most mods can be managed with the Desura client.