It limits visibility for others, but does not prevent the same type of content from popping up for the user who downvoted it.

Further, there is no "karma", so you won't see less content from users who have received many downvotes.