No, it doesn't turn me off actually.
Its an unneeded feature, mostly seen in shows that are in a desperation attempt, or where made for the reason to show off a little bit.
Anime like Bakemonogatari, Soul Eater, Welcome to the NHK, or Gurren Lagann have elements of ecchiness or fan service in...