I played this game on Playstation 2 from 2004 to 2008. At that time I migrated to some Playstation 2 controller shaped things by Logitech. But those have broken over the years. Currently I use a regular Playstation controller but I run it through an adapter to turn it into USB.
Here is a list of products on Amazon.
I use this one, but it looks almost sold out.
This one looks nice too.
If you're migrating from Xbox, I'm not sure what those adapters might look like.