You can turn off steam using a certain controller type (or all) but by default it takes them over. It can cause problems with some software, and apparently doesn't leave controllers in the same state afterwards.

Works well for me though, the only time I use controllers is for steam games and it handles all the mapping/customization pretty well