Yes, it is worth it if you mine CPU coin but be quick, it is going to go all GPU soon.
Which altcoin is still CPU-only at the current moment?
AFAIK none.
Even cryptonotes are mined by GPU's recently. You can try Boolberry, I believe it's still CPU only but not sure.