The killer software is one-off custom things that are written for an audience of one user, or maybe a small handful of them. The software is on their computers, where you don't see it.
None of it does anything particularly amazing, but that's kind of the point -- the programs that people are generating are for the use cases that are too personal, trivial or specific for anyone to have bothered making a software package for.