I like to think of Sephiroth as a tragic hero, rather than the greatest villian. I'm not sure what the greatest villian would be, as I don't play loads of RPG games, just Final Fantasy and those others that hang outside it.
Tragic hero, I think, because he was born into his fate unwillingly - still considered a hero to many until he went insane. IMHO