I definitely think they add to the replay value of games.
It certainly doesn't necessarily mean you're a good gamer. I stink & I have a gamerscore of over 25,000. I do try & earn as many as possible per game. It's just a personal thing I have about finishing what I start.
I also like to compare common games with my friends.
They're meaningless, but they're addicting.