I think it's all about circumstance, and the type of VN; I'm all for the derpy "oniisama pump my ***** full of your ****-**** until I'm pregnant!" porn-fluff when it's a nukige. After all, you buy it/download it knowing (normally) full well what you are getting yourself into.
Story-driven VNs, it's alittle more complicated... I personally prefer a more emotional/connected hscene, if it is to have one at all. I don't think they should be removed - as sexuality is just as important in a relationship as anything else - but overplaying that hand can just lead to /facepalms. I think EF did them right, and even one or two routes in Katawa.
As hot as some scenes are (and I like alot of them in the same base fashion as anyone with a pulse and apprication of 2d), It can come across as excessive, a obvious tool thrown in to cater to the porn-hungry.
Like I said, it's a complcated issue - the "good" VNs really don't need hscenes to stay "good" (1st time I read FSN, I had completely forgotton it was a hentai VN until the first one started lol). But at the same time, they woulden't be the same without them~ Even Clannad - which I loved with all my heart, somehow felt "off" by not having hscenes, even though it does "not" need them. Perhaps some of us are just conditioned from all the blatant sexualization in anime/VNs, to expect it~