Using the Steam method, your controller should automatically switch between normal mode and mouse mode, but only for Steam games. If you want this to happen for other games, go to "Games-> Add a Non-Steam Game to My Library" in the Steam client. Then look for the game's executable file and add it. If you launch it from within Steam, the auto hand-over should happen.