I'm mostly familiar with EV Nova and KOTOR mods, which are posted to websites that probably filter for obscenity. EV Nova doesn't really have pictures of people; but KOTOR definitely has plenty of appearance-focused mods (including one described as "More sexy underwear for females"), and on some other games I have heard of mods that fall into the "weird porn" category.