Re:TIGER -- look again (Score 3, Informative)

I think TIGER is the way to go. One of the things about using TIGER data is that it has its own data format, however there are converters out there that will convert them to SHP format, which can be used with pretty much everything (i.e. MapServer and PostGIS). There are also companies that offer converted data from TIGER (albeit for a price, but it does take a little time to actually do the conversions yourself).

All of the street level labels are there too, which makes it a very good source of free data. I've been using the data for my own project and it was fairly easy to setup.