So far I've only seen 2 offensive things on Miiverse, the first (a bad penis drawing) took less than 20 minutes to be flagged the other (someone calling ZombiU reviewers "mindless fucktards") was taken down in less than an hour.
It's a great community and I'm hoping that it spreads quickly. :)