No, the Steam deb is special because it's not in the normal apt repos, which is true for both Ubuntu and Debian. And I can believe that Debian has issues with an installer file that was probably made for Ubuntu in the first place. But downloading random installer files is indeed the standard way to install applications on Windows.