No general is useless. Even the worst general allows you to control what is and isn't being constructed in a town. If he's bad enough he's detrimental to the public order, just have him sit next to the town so he can pop in, get some stuff done, then head out and fight rebels.

I usually have a handful of such "field governors" that only go to town when I need something done there.