Curation rewards is still a whales game. It's based on the square of r-shares, and therefore the larger players make far more money in curation.
If you make quality posts and upvote them, helping get them visible to other users, then yes it could be very much worth it financially.
Hmm... I wonder if there is a webpage where you can count how much money can you give with upvotes for the specified amount of Steem Power.
there is check: https://steemnow.com/upvotecalc.html