Your TL78L05 may have roughly the same noise spec as the TPS793 family, but the rest of the specs will tell the real story. Take a look at the PSRR, dropout voltage, and line and load regulation. The TPS793 beats it all hands down.
Now, if you have a pretty clean supply coming in (don't need high PSRR, or good line reg), don't care too much about power dissipation (high dropout is ok), and your load is fairly constant at low frequencies (only used for biasing RF components, no current transients, etc), then you don't really need the TPS793xx and can try out the TL78L05 regulator.