as far as the casual downtown spots go, wynkoop is IMHO by far the best that i have tried. equipment is in decent shape (mostly 9" GC3s) and i've never had to wait for a table (only been a couple times ymmv). tarantula has pretty run down equipment and is very rowdy. long waits for tables too.
another couple no one has mentioned are :
GK Billiards: (no food or drink offered there) very well lit, lots of carom tables, only 9 foot pool tables. dynasphere or aramith balls. simonis cloth
Vihn's Son: (cash only) huge space, lots of tables pool and carom, good homey vibe. good vietnamese food and cheap beer. table rate is also pretty cheap.