Besides the writing not resembling anything Roddenberry would’ve made, the bad acting and pandering were really off putting. I’m genuinely surprised it even got renewed 4 times.
I know you said you don’t want to buy second hand, but if I were you I’d buy a 6800 xt second hand. That’s by far the best bang per buck you’ll get. I’ve been buying second hand gpu’s for over 10 years and have never had any trouble. Just don’t buy any dirty, overclocked or used for mining cards and you should be fine. I already looked on OLX and there are a few between €350 and €400. If you really want to buy new I’d go for the 7600 xt.