I don't see myself improving, I just see myself putting in immense effort in order to not get even worse.
How old are you?
I'm almost 40.
For me, part of the gym is now "in order to not get even worse." That is....reality. And it will become more so the older I get.
Effort = Results
If you're not vomiting or blacking out, you're not trying
There is surely happy median between "blacking out and puking" and "not being challenged." If you're anywhere near that median, you ARE doing the work. Maybe you could do a little bit more, maybe not.
I think you're just too hard on yourself man, obviously. You sound like you've got general unrealistic expectations of yourself and that's just extended to gym.
The exertion of every rep is failure and humiliation, because it's not the weight/the ease it "should" be.
In the gym, forget about "should be." Focus on "is." The numbers don't really matter, not unless you want some kind of social clout for reaching them. What matters is the internal drive to try, to maybe get better. You need to allow yourself your successes, IMO. Like, actually consistently working out for a year IS an achievement. Your clothes fitting differently (i.e. change) IS an achievement. Hell, getting through your sets when you're tired and part of you wants to quit IS an achievement. Allow yourself that momentary satisfaction. Working out is hard enough, beating yourself up on top of that for not hitting numbers isn't / hasn't made your gym experience better. When it comes to headspace, I know someone telling you a thing doesn't really matter. Telling is not being. But gym shouldn't be about making yourself feel bad.
I kinda realized a while ago that, for men, most of "fitness" comes down to one essential concept: "I can beat you up." That's it. The numbers, the swole, the looks......it's all about feeding our egos that we're strong, that we could kick someone's ass if we had to, that you could kick THAT dude's ass in the gym if you had to. (Maybe not THAT guy with the arms like tree trunks, but surely THAT guy who has no chest.) Tangentially, also, that you're a prime specimen for breeding.
It's bullshit and the root of many men's insecurities. The older I get, the more I realize fitness should be about longevity. You know what's not conducive to longevity? A 400pnd deadlift. A 345 bench. A 350 pound squat. The numbers DON'T matter. What matters is that you move, that you if nothing else KEEP your strength and your mobility so you can live. Looking good, looking swole, looking ripped, those are a bonus for real people with real lives. It may be the primary focus for "influencers" and people who sell themselves on their appearance or their reputation. Their stress to "be the best" and "put up the numbers" isn't going to be helpful to you if it doesn't positively motivate your training.
"Should" being the operative word, again.
You're smart. You can watch some Youtube videos on different exercises to figure out what you should do and how you should do it. If you haven't.....that's simply a lack of follow through, probably stemming from your other hang ups. It's easily correctable. Just spend a week watching a couple different exercise videos a day. Start with the body part or muscle group of interest to you, search youtube and go.
What I need is a damn reboot of my sick head. And I'm working on that.
Working out definitely isn't the panacea for all ills for everyone. For me, my head space was totally fucked from a lot of different things, but gym helped me push out the useless mental wheel spinning by giving me a goal I don't have to
think about, I just have to
do. But I get that's not necessarily enough for everyone, and after a while, it becomes a routine and other nonsense slips back in. So yeah, I hope you can find some help so you can, if nothing else, learn to enjoy and appreciate training and by extension, your own successes in it.
I'll leave you with this quote from my sig:
Cautivo del Milagro seamos, Penitente.
Let us be captives of the Miracle, Penitent One.