What is worthy of your upvote is entirely up to you.
The resulting sum of upvotes is expression of community opinion, but it goes from individuals to the sum. Not the other way around. Community doesn't and shouldn't dictate you this.
Always vote in line with what you think about the post.
Site docs put it simply like this:
When should I vote up?
There are currently 47,701 answers with 0 votes out of our 123,069 answers (38.75%).
4,212 of those answers were created in 2019.
Please take into consideration the quality of the answer before upvoting said answer. Low quality answers should be reported and a comment should be left asking the OP for clarification or to edit their answer and add any ...
First of all, thanks for informing us.
You didn't do something wrong if you didn't know how the system works, Could happen to everyone. Now that you know, you shouldn't do it again. The system will can detect such behavior and a mod may find it suspicious, maybe enforcing a suspension on your account if it continues. You can read more about serial voting on ...