Well, I can tell you that one 3D game (outside of the 3D FPS realm) that makes me pee in my pants is Medieval: Total War. This is the wargame I have ALWAYS wanted. Lined combat in medieval Europe, with EVERY soldier modeled. The next release is Rome: Total War which is going to be ENTIRELY in 3d (no more sprites), and I have a feeling that this title will make me weep like a small child in a Turkish prison.
I feel very Sun Tsu when playing the Total War series... Brilliant, brilliant strat.