Get yourself to Empty Bottles in Leeds,seedy,tatty,grotty toilets,hot hell in summer,hot as hell in winter but music & atmosphere to die for.
A close second is Bradford rare & underplayed at mill lane,it's a great side room of a pub that's like "Shameless",again a night full with atmosphere & great music.
Just behind them is the new room for Driving Beat in Leeds,a great room with a small raised dancefloor but most were dancing on the stone floor but who cared as there was such a buzz & music to match.
So yes still some interesting room to be found.
Cheers
Martyn