If you want to try a classic X-Com game you want to look at X-Com: UFO Defense. Its sequel Terror from the Deep is only really worth looking into if you already know the first, and the third game X-Com Apocalypse is very different and not as universally well liked (As well as lacking a finished source port so far).
The classic and the "new" X-Com game are very different, so it's not easy to tell if you will like one based on liking the other. Gameplay is very different in the classic games, with much more freedom of choice, but it's also less guided and probably harder to get into. But, it's really a great, unique game, and can be played very easily using the source port
Open X-Com. I recommend looking up some videos to see if you'll like it or just giving it a go!