Still a bit dated, like it's predecessor, but I found myself frustrated much less, and the levels are also a lot more varied in this than the first Splinter Cell. Highly recommend, if you can deal with the poor PC port!
It's shlock, basically Call of Duty: Rome but it's still lots of fun. Ended up not finishing it because the copy of the game I downloaded kept crashing, but it's definitely worth a try.