i recommend you go to O bar in soho, late at night when you are too intoxicated to get in elsewhere.
Ironically sandwiched between the legendary gay haunts of Old Compton Street and Wardour Street, The O Bar is an ostentatiously straight venue that I found to be rather sleazy. Think Hooters, and you won't go far wrong... Although there is the usual bar service, scantily clad, overly made up and very 'thrust-their-bust-at-you' waitresses will harrass you at your table and try to get you to order your drinks from them, in hope of being tipped for doing... Well, not a lot, really. Unsurprisingly, this is a big hit with the polyester suit-clad guys who fill the place, attempting either to get lucky with the waitresses, or just impress whatever hapless female they've managed to lure into the place. Quite honestly, this bar is mostly frequented by those who want to drink in Soho, but are too homophobic to go to any of the nicer, but not exclusively straight bars in the area.
http://www.tripadvisor.co.uk/ShowUserReviews-g186338-d2278677-r136930687-The_O_Bar-London_England.html
Like the thread title says. I like some places like Barfly in Camden. Ronnie Scott's has some great acts but it's quite overpriced imo