The opposite of useful is useless. I don't imagine feeling useless is very pleasant. Isn't it even an insult... "Hey buddy, you're completely useless. A fucking waste of space and oxygen."
Maybe the desire to be useful is another evolutionary thing we developed, so that both the individual and the group has smth to gain... And yeah, usefulness is related to value. When it comes to objects, and when it comes to people.