I used web.py heavily in the early days on many small websites and one large website at work (well after it was relatively unmaintained). It was an early "microframework" that was really nice to use, and simple to hack on as needed. I liked its KISS approach to pretty much everything, including database handling (a thin, Pythonic wrapper around SQL, not an ORM). It was quirky in places, though -- I suppose not unlike its original author.

I'd probably use Bottle now, for equivalent simplicity and hackability, or maybe Flask (though that's significantly larger).