Ironically, T-Pain, arguably the poster child of using auto-tune, has a great singing voice[0]. Apparently he used it on purpose to stand out.

Probably explains why it works much better for him than for others: he used it as an instrument, not as a crutch to hide a lack of singing skills.

[0] https://www.youtube.com/watch?v=91ck0vJBygo