I use Big Picture because I have a Dual Sense. Maybe with other controllers you don't need it but windows has a hard time letting me use it even though it's, supposedly, 100% compatible.
I have to add GoG games to Steam Library because otherwise I can't use the controller without Big Picture.