I've decided to go back and play Redemption again but I want to know if there are any mods that will any mods will add more content? Or what will the mods that are out add?

Age of Redemption is probably the best option. It also allows single player campaign in multiplayer co-op.

http://e-mods.net/modules/mods/about_aor.php

Multiplayer doesn't really matter to me. I'm just looking for mods that work in single player games. Do you know of any other mods that are compatible and are good?

Age of Redemption can be used in single player campaign as well. To add some content, like the ability to play as a different clan (and the added Lasombra), you'll need to use the multiplayer option. However, you don't need to play with others in MP, you can have your SP coterie with you just like in the regular SP campaign. You don't even technically need to be connected to the internet to do that. There's config menu when AoR launches that has a ton of options related to AI and their "pets".

Anyway, there is also a host of other mods that add content/spells. Emod is one, and can be found on the same site I listed previously. SIX Mod, WoD Mod and WTD Mod are also popular mods that add a different experience. They can be found here:

https://legacy.planetvampire.com/modules/files/?id=7

I think I'll try out AoR for my current re-play then I'll check out some of the other mods. Right now I'm just going to see what I can find out any other mods for Redemption. Such as if the creator is updating them, how buggy they are, if they'll work with win 10, etc.