I've had no such troubles. I play Rocket League with my steam controller regularly. Sounds like you might have gotten a bad one, did you contact support?
As I mentioned, once things were configured in a game, it worked mostly. But for no good reason, would fail sometimes either at detection, or if I turned the controller on before opening Steam in big picture mode, it would also often cause conflicts with it not knowing if it was a mouse, or a game pad, or a controller, or what it was supposed to be.
There were enough forum posts around with folks having similar issues, that I guess I just assumed you had to be willing to spend time tinkering a lot if you wanted it to work, and thought contacting support would end up being an even larger time sink.
Those are just a couple of examples. Attempting other games would end up with incorrect mappings, incorrect button listings, not working, and more.
