You absolutely do need SDL, it's full of knowledge by humans from trial and error over years of using input devices in the real world.

Xinput is a pretty constrained interface that plenty of novel controllers, including steering wheels, don't/can't adhere to. Good luck getting the PS5 controller's fancy rumble working over xinput, for example