I love silly mods like the googly eyes mod for Darkest Dungeon and the smiling leader portraits mod for Hearts of Iron 4. Those are truly one of the best genre of mods.

MC Tammer's NIF bashed weapons pack for Fallout 3 and New Vegas is totally awesome. Theres a gazillion guns of all sorts including a lot of non-lethals, it adds some extra attatchments and ammo types too. All of the weapon models are made up of parts of weapon models from the games themselves so they actually match the aesthetic pretty well. Highly reccomend the mod itself since its well integrated with the game with NPCs selling and carrying the new guns. One of the custom vendors (which are all optional) is a stereotype of russian people (think FPS Russia but hes a gunsmith) and that was kinda cringe at times.