No melee weapons is inexcusable.  I can ninja sword my way through the hordes but using my pistols is just...sux.

Doubtful that you even played it. There was plenty of ammunition, special ammo, an throwables scattered throughout. If you took a bit of time and looked it was there. I've played it twice now. Melee weapons were not pressent. However by using two pistols I could easily handle the hordes and save my main weapon ammo for specials.