Valuable to whom? You? Me? The people who love them? Themselves?
Value measured how? By how much attention they get? By how much money/power they have? By how much "good" they've done for others (which is a whole different can of worms--defining and measuring "good")? By how many other people love or care for them?
Our societies do rank people by value, using a wide array of criteria. We don't agree on which criteria is best, or correct, though.
Ideally, we should consider all people equally valuable generally, if you can get to that place in you heart, then no other opinion matters. Of course, to each of us some people are going to be more valuable than others. My son and myself are equally the two most important people to me. I rank everyone else equally valuable but less important to me personally, and I try to view them that way.
I'm following your rule that we're not including serial killers, etc.
The only people, generally I rank as useless are billionaires. Every single one of them could disappear right now. The world would be a much better place and no one would miss them. No one, not even their families. We've watched this play out recently--Charlie Kirk's wife, Trumps entire family clearly despises him while being no better themselves, Musk's kids all hate him, etc.