Why do composers find string instruments (such as violin) so compelling to write solo pieces for, in the absence of harmony?

Because it does have harmony in place: Double stop.

Now: how many solo pieces are there for brass or woodwind instruments? And how many of them are as renowned as the solo pieces for strings (including plucked strings)?

I think you have your answer.