Do you mean Cassandra (BigTable), MongoDB (Document), Riak (Key/Value), Redis (Mix), Kafka (Log Structured) ? There are dozens of fundamentally different systems many of which are closer to an RDBMS than their NoSQL peers. And many of them have rigid schemas so it definitely isn't that either.
Graph databases arguably handle relational data better than SQL, and I'd argue they're much nicer to work with.
> For instance I've issues to see how modern SQL systems can replace CRDTs based stores.
They can't of course, but it's not only CRDTs. SQL is incompatible with a lot of things that came out of distributed systems research. Just like POSIX filesystem APIs or pretty much any legacy stateful tech. And no amount of PR articles can fix it.
Have an index on the score and select with ORDER BY ... LIMIT?