Well, if you like RPGs and also want 2D, I would recommend Baldur's Gate 2 highly.

I know what you mean about DS - what a boring game. A better choice for a 3D game would be NeverWinter Nights, although some people don't like the single player game too much. I enjoyed it personally, and played that before playing DD. 3D is nice in some respects such as being able to zoom and rotate - but to me it really comes down to how engrossing the story is and how fun the game is to play. So, again, I don't think you can go wrong with BG2.

Cheers