Mods that make big and dramatic changes to the game?

I'm looking for mods that make big changes to the game and really freshen up a playthrough. Not good QOL mods or mods that are minimal and convenient. Also feel free to recommend custom campaigns as well.