I always wonder what is the ratio of these projects that do "solve problems" and that appear to "solve problem" and that do not "solve problems"...

Most of times people would say the do solve them. Still I might or might not be right that quite often they do not in reality.