Everyone should start here with the Stardew Valley Wiki Player’s Guide to Getting Mods. Another excellent resource is this Youtube guide by Salmence.

Unfortunately, a lot of mods end up dead over time.

However, community members will sometimes get permission from mods creators to maintain and update them. SMAPI will sometimes link to mods that have been updated by third-parties.