Am I not really good enough for the people I care about? Why can't they appreciate me?

Only you can decide that. But you must be true to yourself. If you’ve hand-on/heart done the best you can for them and they don’t appreciate you, then those people are not suited to be cared about, and you should try and find new people.