I enjoy it to an extent. The tongue slightly out, dewy eyes, and a bit of a smile (possibly a little drool) is good... Anything beyond that just looks like they were taking drugs and are having a bad trip.
I'm in the middle. There are some Ahegao scenes I find fucking awesome and there are some that I just can't take seriously, end up laughing at it and lose my boner.
I really want to say "It has to be used subtly to have appeal," but I've gotten really into some books that are incredibly ahego-centric. I see it as a multiplier though; if your art is bad beforehand, ahego will make it worse. If it's good, it'll be better. Provided it fits the scene. All in all I like ahego allot as long as the artist doesn't try to use it as a crutch.