Running Steam vs running a game is two different stories.
I’ve tried it, and the experience can be hit or miss, but that depends on what type of experience you can tolerate.
Some games work perfectly fine like Windows where you just click install and you’re good to go. Others require you to put some work into it. If you don’t own/play a lot of games, it won’t bother you much, but if you do, the time for troubleshooting can add up. If you enjoy troubleshooting computers, it also won’t bother you.
The biggest thing to consider is whether or not you’re into a lot of online gaming. There’s quite a few that have anti-cheat systems and the simple fact that you’re running a Linux distro will get you banned no matter what.
I played Dota 2 on Steam for Linux installed on Ubuntu a few years ago. Dota 2 ran pretty good on Ubuntu Linux. I also ran Quake 3, and Minecraft on the Raspberry Pi mini PC which used a version of Debian. Quake 3 and Minecradt ran well on the Raspberry Pi.
I use Linux on my old laptop but I can not say that I have ever tried to run Steam on it. I was aware that you could use Steam on it but just have not gotten around to installing it and giving it a try.
For how much I use Steam though at the moment, I don't think it would be worth it, at least not at the moment for me to install it.