I think a hybrid makes a lot of sense for regular drivers, especially in city driving. My parents are looking for a newer car, and I'm convinced the 2nd gen ('04-'09) Prius is the best option. They do a lot of city driving and don't hypermile. No non-hybrid will get even close to the Prius city MPG. Especially with an automatic. And at least around here, a used Prius doesn't seem more expensive than a similar-sized non-hybrid.
For hypermilers, I think most of the hybrid advantage doesn't apply. I averaged over 70 MPG last Summer in a '91 Civic Wagon. I don't think a Prius could do much better. But I'll try to prove myself wrong every chance I get!