Honestly, I was more miffed about them cutting out the decapitation scene, the bath scene and the one where Ursula drops her pants to prove herself to the sailors.
As for actual translations, Breath of Fire II is about the only one I can think of off-hand that left a rather... unpleasant taste in my mouth. Final Fantasy VII had it's moments as well though. !#$#%#$^ and all that good jazz.