Mmm, I know exactly what you mean. I'm tired of limp lead characters who just tick the boxes of a target demographic to self-insert into.
The Expanse suffered a bit from that (the main guy had all the magnetism of limp celery) but was saved because every single other character was genuinely interesting. Farscape had a much smaller cast, so there was no escape!
That could be said of a lot of things ... a great concept let down by lazy writing and poor casting. Yet these things get money thrown at them - great effects, lighting, locations, makeup, etc etc