Have I felt the exact same emotions as you described in the OP?
Yes, many times.
Whatever you have described is mostly true. There is bias. On both sides. Changes you made will eventually get changed. People will sometimes praise you. And the same people will sometimes hate you too. They will ask for help, and they will also talk behind your back.
I've always personally felt that if you are going through these things, then you are doing your job right. Because the only way you can make everyone happy here is if you do it wrong. This is a site where people have different opinions about virtually everything, it's impossible to please everyone. You can't stop people from hating you because you had a different opinion, but you can feel good about not being a people pleaser, standing your ground, and doing what's right. Being in a position of responsibility is not easy here. And the greater the responsibility, the more you have to deal with these sort of things, and the more you learn, to the point where these things stop bothering you. At the end of the day you realize that there is no 100% agreement on anything and that's how it is, you just learn to deal with it.
From personal experience, taking a short break, to detoxify yourself, works wonders in these situations.