Yes, it does! There is no need to install anything extra or to change Steam Settings.

The PlayStation Configuration Support option under Steam Controller Settings should be kept switched OFF, however: