We didn’t get too many requests for smaller packages for the PSOC 3/5LP devices in the past and hence did not create the same. Since this is an old product, we dont see Cypress creating new packages for these. You should be able to find smaller package options in PSoC 4 or new PSoC 6 families. Which package is of prime interest for you and your application? The QFN or DIP?
It's a sad news to hear that the 5LP series is considered old. I'd say it is the only useful part in your portfolio. PSOC3 is based on MCS51, the resource-deprived PSOC4 looks like a joke, PSOC6 is extremely disappointing (still no Ethernet MAC, removed the useful blocks like the DFB, only the BGA packages). The most useful combination for me would be a 5888/5688 in TQFP32 and TQFP64. Both.