Earlier quoted context omitted.
It's true that in small claims you often don't need one to represent you in the actual proceeding - and many lawyers, especially fairly "big" ones, would have no interest. However, retaining one to advise you on how to navigate the process, how to phrase your arguments, how to communicate with the opposing party, etc., is probably valuable even if they aren't running the case for you directly.
My company had a fairly expensive lawyer on retainer when we had a $3-4k bill go un-paid and was forced to start a small claims proceeding in order to get paid. Since we had never been through something like that we asked him for help, and he did help us quite a bit, because it became quite a hassle. I assume that he assumed it would just be a couple letters drafted and they would cough up, but they really dug in the…
Frankly, at $500/hour, I would politely tell him that I will bother him with whatever I need, he's not doing me a favour.