The software around controllers is universally bad, and Valve is the first to really try to fix it. We need a successor to XInput that is less limited.
It's been driving me crazy seeing all the hate Valve is getting over compatibility concerns when Valve is the only one making controller support on Windows outside of an Xbox controller work. For years I just assumed I couldn't use many of my controllers on Windows, until Steam added the ability to act as the in between and properly handle it. Microsoft has no interest in making anything other than their Xbox controllers work, and everyone suggesting some sort of "I can just buy X as an alternative" has some major caveat that gets conveniently ignored.
This isn't to say that you're wrong about your main point. Steam is heavyweight to use just as an input profile selector at application launch. But you should be careful about details if you choose to include them.
I've no relationship with the brand btw, I'm just a happy customer.