I think yellow coral goby may "irritate" sps rather than kill them. But, my clowns irritate corals initially, then the coral gets use to them and learns to live with them. My hammers rather happily live with all the rubbing (body to body), mouthing, sucking etc from my clowns. I'm actually quite envious.
I had a yellow coral goby for a while, but it didn't eat and got very thin and so I gave it away hoping it would do better in its new home. That is why I didn't mention it. Maybe I got one that was already on the way out?
I did get another coral goby from a fellow aquarist, but around that time I introduce a tiny lionfish into my tank and I noticed the Lionfish was sitting a lot around the spot where the coral goby was living (at that time). Needless to say, that goby didn't last very long.