It was a great game, for its time. Like most old games, the majority of the people who will play this are people who will more than likely played this at some point, either to completion or not. The mechanics of the game are for its time, as well as many aspects of the game. The story is nice, and if you can play it with the understanding it is an older game, then you should have a decent time. My advice would be to either get this on Switch or get the original Xbox version (for use on Xbox One or Series S/X) if you want to have a (mostly) stress free time running this game. On a side note, I find it ridiculous to see recent reviews claiming "left-wing" propaganda on this game. This is an old game, with all the trappings in programming, storytelling and tropes of their time, sure, but honestly, the examples they put are skewed at best. The concepts that they allude to in some cases were not even a hint of one back when the game came out! People will see what they want to see though, if they look hard enough. Still, ridiculous to see such narrow perspective on things they don't like... It is a game. Treat it as such and you'll do fine. Again, if you get the GOG version, be prepared for some compatibility issues.
