Yes, BG 1 & 2 were really awesome. The only thing that I've played recently that has drawn me in the same way was Elder Scrolls IV: Oblivion. It's a very different game, but it reminds me of BG2 in many ways--the big capital city, lots of different quests hidden throughout the world, fantasy setting, etc. Neverwinter Nights didn't do it for me--I played it, but it just didn't recapture the magic. After reading the reviews of NWN2, I'm going to give it a miss entirely.
Mass Effect and Bioshock are going to be my next RPG's. Currently I'm playing through Oblivion all over again on the 360--and finding that the 360 controller works much better than the keyboard and mouse in that game.