Basically, yes, Kefka is tragic, but not remotely sympathetic. The same goes, to a lesser extent, with Sephiroth, but as you said, there were a number of missed storytelling opportunities in FFVII that left him a much less tragic and/or sympathetic and/or multidimensional and/or identifiable-with villain than he could have been.