Just found the solution in the solution in the arch wiki. I needed to enable nscd for dns local cacheing, for some reason. After running sudo systemctl enable --now nscd, Steam now connects without an issue. I'm not sure why this just cropped up now, but I'm glad it's fixed.
Assuming you’ve got the necessary lib32- packages installed, this kind of sounds like an issue with your DNS resolver - if you have to refer to a local cache then the DNS resolver is not working correctly “after some time”.
The section on the wiki talk page doesn’t shine much more light on why ncsd is needed…