I've just read this:

http://www.rockpapershotgun.com/2013/12/11/this-is-the-scariest-skyrim-mod-ive-ever-seen

Some of the comments are pretty funny, but theres a link to a Macho Man Randy Savage mod. After sharign the link with a few people, I was getting links for a My Little Pony mod amongst others.
It took me back to the time before I used digital distribution and had to rely on modding to give games the extra mile (instead of having a bunch of bundled games to choose from), and some of the horrors and completely useless ones out there.

So, what are your funniest / weisrdest/ most incomprehensible mod finds and memories?!

I remember reading years ago about a mod to remove the spiders from System Shock 2 because they were just too frightening for some people. I do see the sense in this, but it does make me smile.

That Thomas mod made me laugh pretty hard, but that might have something to do with me enjoying Thomas the Tank Engine when I was a youngster.

One of the scariest mods I found, which is mostly scary because it is crazy that someone came up with the idea, happens to be the Cybie series for Doom. I am not going to spoil too much since it needs to be seen to be believed, but it involves Cyberdemons and your fists.