With all of the supporting chips required (instruction counter, etc), why not design something in TTL? What was the advantage of this chip?

Well, that's probably why the chip wasn't super-popular :-) The chip reduces your part count somewhat -- it would take a bunch of TTL chips to replace it -- but it's not like a microcontroller that solves your problem entirely.