Troubled downtown club tries to briefly rise from the dead, but residents, businesses and police want to stuff it back in grave