I think popularity and regarded favorably are probably inversely correlated.

Many of the most popular languages are also the most hated. Many of the more niche languages are viewed the most favorably.

It is easy to dislike something yo are familiar with, and easy to be overoptimistic about something you don't know as well.

"the grass is always greener ... "