Honestly Yangus, if you were "repelled" from watching more of the show simply because of the way it looks, and the kind of story S1 was telling, I don't know if watching the rest of the show will really change your mind.
Discovery has changed quite a lot between Seasons 1 through 4. There was a fair amount of stylistic changes regarding less dutch angles/lens flares, less cursing and general violence, more ship-porn, continual realignment of the supporting cast around what worked and what didn't, shifting the story towards feeling a little more episodic in nature (but never jettisoning the serialized nature of the show's overarching plot lines; think Enterprise S3), etc, etc. But at the end of the day, Discovery still remained steadfast to being three things:
1) A "cinematic experience" at home: For better worse. (I think better most of the time, but that's always going to be a ymmv decision.) I think Discovery, and most cinematic experiences in general, works best when you can put it on as big of a screen as possible that fills as much of your field of view as possible. Some stuff just looks goofy when you shrink it down in size, but when it's taking up your whole field of vision it looks cool. When I watch Discovery (and nuTrek in general) I'm seated about 2ft away from a 55" screen, so everything looks incredible to me. Even the dutch angles lol. I've posted this clip a few times, and it's HUGE spoilers for S2, but man is this some of the coolest, most cinematic stuff ever done in the franchise:
2) The "Michael Burnham Show": A lot of Star Trek fans grew up on TNG and expect/insist that Star Trek ought to be an ensemble show, focused narrowly on the "bridge crew". I think that's an extremely limited, illogical, and myopic perspective, but it is what it is. Discovery has a supporting cast (that I think are awesome), but it was never and will never be a show about a traditional bridge crew. Discovery was a show concerned first and foremost with a main character and her personal journey. To me, the Klingon War and Mirror Universe overarching stories in Season 1 was kind of whatever. We've seen these kinds of stories before, this permutation of them wasn't bad but they weren't great either. What
was interesting (at least to myself) was Michael's personal journey through it all. "Star Trek: Discovery" is called what it is, in large part because the show focuses on the personal discovery that Michael experiences as she figures out who she is as a person, what is important to her, and what she wants to be. If you like Sonequa Martin-Green and can buy into her acting, there's a really fulfilling and compelling character development arc that has steadily grown from S1 on through S4. If you can't be convinced to care about her or her journey, then the odds are already stacked against you enjoying the show.
3) The reaffirmation of hope in the face of despair: Every season has had this as its primary theme. From the big overarching storylines, to small character moments. Discovery is very much a show that - having launched in 2017 - was informed by and a firm rebukement of the post-Trump world we find ourselves having to navigate in. That even when things seem like they're at their worst, or when you're facing a situation that seems hopeless/impossible, or when our ability to even communicate with one another seems compromised because we don't even appear to experience the same reality anymore. Holding onto hope, remaining steadfast in our morals rather than compromising them, never giving up on compassion and understanding as essential tools for forwards progress, and maintaining our own identities/being the authors of our own narratives instead of letting the times or our enemies define us, Discovery beats these drums in a way that I found to be earnest and authentic. The way S1 approached this message was very hamfisted. S2 spent most of its energy modeling how grace and composure ought to look as a contrast to the lack of such in S1. S3 and 4 I thought nailed these ideas superbly.
If a show oriented around these three concepts doesn't sound interesting to you versus a more modular, classical Star Trek experience, I think that's fine. The great thing about nuTrek is that there's flavors for everyone. And it's ok to just pick the ones you like, you don't have to force yourself to watch them all.