I recommend the Brook Series, they have a consistent brand of products that work with PS3 Stick to PS4 or Switch etc.
only certain fighting games allow PS3 controller backwards functionality, the only one that comes to mind is Ultra Street Fighter 4, you must have a PS4 controller connected in order to connect a PS3 fight stick to the game