Even ignoring the trend towards sanitizing the game and making everything "family friendly", such things still don't fit the cartoony, silly vibe of the franchise. I may not be opposed to seeing some of these things in an unmodded sims game, but they'd certainly make me do a double take. Admittedly, it might be fun to have some sims have an affinity for drinking or smoking (just for more personality variance) but as a matter of personal preference, I'd prefer nudity not be included. Blood and violence are mood dependent, I'd rather it not be put in but every now and then a townie is too annoying to live and you gotta break out that Extreme Violence ?
If anything, I'd like to see EA work with CC creators and console simmers to make mods easily and safely available for all. Not sure how they'd do it, but it'd be neat.