I searched for solr sucks and got 20k hits.

Not here to defend solr specifically, but every tool has trade offs. Solr is popular and there is a lot of documentation, so it is not a bad choice for a document search database. Now, picking solr without understanding a document database and its tradeoffs is a problem, but not solrs.