First I have to agree, basically all mods for Rimworld are on Steam.
And yes, you will need SteamCMD to download them.
But I really recommend not using it directly.
There is an awesome mod manager called RimPy.
You will find a link in the description here:
https://steamcommunity.com/sharedfiles/filedetails/?id=1847679158 Or you can go directly to:
https://github.com/rimpy-custom/RimPy You can browse, download and sort your mods comfortably with it.
It internally uses SteamCMD but can be used even without a Steam account (logging in anonymously).
The first mod I'd recommend is the the one from the first link.
It is a meta mod that provides RimPy with a database to better sort mods.
Now for further recommendations, that is very much dependent on your own play style.
From little changes like P-Music for more in game music or RimHUD for a better overview of the informations,
over quality of life mods like Achtung!, which gives you better control over your pawns,
to DLC sized mods like Rimworld of Magic, which introduces classes and RPG elements,
and even complete mod frameworks like the Vanilla Expanded Framework, which has more mods than I could list here.
There is a mod for almost anything (and enough reasons for me to have over 500 of them installed).