AMD GPUs are usually the best pick for Linux, and the RX 7900 XT is capable of a lot better performance than 0-10 FPS. (It will vary by game, settings, and resolution, of course. You didn't mention the latter two.)
It's possible your games are using the CPU's integrated GPU instead of your graphics card. (Your iGPU is made for desktop use; it's not suitable for most gaming.) Do any of your underperforming games have a screen that shows which GPU they are using? Is your monitor plugged into the motherboard's video port, or one of the graphics card's ports? Does an overlay appear in the top left of the screen if you put DXVK_HUD=1 %command%
in an underperforming game's Steam Launch Options?
It could also be that you don't have a recent enough kernel, firmware, or mesa/vulkan drivers installed for that fairly new GPU model.
Since you bought from System76, I would guess that they have support staff who can help make sure these things are set up properly. They even have their own Linux distro, which I think is pretty well regarded. Have you called them?
Is this as good as it gets?
No. Not even close.
EDIT: Added note about DXVK_HUD in Steam Launch Options