If you already have it, you should give it a punt. You should maybe buy it on sale or something. But it's definitely not a full price purchase, as far as I'm concerned.
It tries do to curious stuff, but fails more often than not. There's some nice verticality to the level design at times, and I like how it discourages close quarter combat by making you vulnerable and letting you carry a pitiful amount of submachine gun ammo. There's also a level where you're caught in a crossfire between the Germans and the Russians, having to fend off waves of soldiers from both sides while you slowly claim ground towards your target. It is The Acest Thing.
At times, Sniper Elite is an amazing powertrip. I once had three enemies in close proximity - one patroling, and two standing guard. I took one of the static ones out, masking my shot with the ringing of a church bell. While the patroling soldier was examining the body, I took the other surviving guy out in a similar way. As the sole survivor turned around, he found another dead body, having no clue what was happening. I like to think he was pretty bewildered as a speeding bullet entered his skull.
Ultimately, I spent a lot of time carefully planning a stealthy infiltration, stealthy assasination and stealthy exfiltration that never was. The checkpoints were too far apart to restart every time I was noticed, and I was noticed far more often than I would've liked. The thing is, I feel like it wasn't really my fault most of the time. The conveniently loud artillery fire would misteriously cease indefinitely as soon as I picked off my first target. Enemy reinforcements would magically appear in places I've already sweeped. Cheap stuff like that.
I had fun for a couple of hours, but I came close to giving up on it several times.