I don't know what goes on to get Steam workshop to be a thing for some games, but there are many others that don't use it. For those that don't use it, simply find the trusted site that hosts them and learn to mod from there.

For Valheim, I hear Nexusmods has a growing selection.