Splinter Cell plays perfectly fine with an X-box controller, having being designed as a console game from the start

However, console controls are very different than pc ones, and a direct conversion would probably make the game feel awkward when played with keyboard + mouse, so be prepared for that when buying the PC version...