They can be a lot of fun to use, but with there being so many and all it's easy to get overwhelmed.
They allow you to do things not initially intended by the developers of the base game, like adding new hair content, or turning into a vampire. A great way to put your stamp on a game like The Sims 4 is to use mods.