Very true about using it to great effect in 808s and Heartbreak! I remember hearing one of those tracks and finding it fairly nice to listen to. Then I heard him live on SNL and his singing voice was close to non-existent.
No-one ever says Cher can't sing, but her 'Believe' song also uses Autotune in a very distinct way.