W 6th and W 9th (both in the Warehouse District) are where the clubs and steakhouses are. Usually full of loud, drunk, younger 20s, obnoxious douchebag college kids (except for the expensive steakhouses).
E 4th and W 25th (Ohio City) is the slightly older crowd (older 20s, younger 30s) where they have classier restaurants (excluding steakhouses). Both areas also have bars, comedy club at Pickwick (E 4th), etc. W 25th has breweries.
Wednesday nights are relatively dead. It's not like Thursday or Friday nights. But, it's better than a Monday or Tuesday night.