Two obvious suggestions are Frank Herbert’s “Dune” series, and Issac Asimov’s “Foundation” series.

Both are sci-fi classics (Dune is still the best selling sci-fi book of all time I believe) and are space operas of a massive scope.

They are also some of my personal favorites.

No love for Iain M Banks? The Culture series looks like it will tick all your boxes and instead of following a single protagonist the Culture itself is the protagonist so each book has it's own cast of interesting characters.

Dan Simmons - Hyperian ~~K~~Cantos. Four books in the series, well worth a read imo... I loved it

Adrian Tchaikovsky - Children of Time / Children of Ruin / Children of Memory (not read the third but am sure it'll be as good as the first two)

A Fire Upon the Deep by Vernor Vinge. I liked the prequel, A Deepness in the Sky even more.

Reality Dysfunction, Hyperion, Red Rising, Dune, The Expanse, Foundation, The Mote in God's Eye

Pandora’s Star and the sequel Judas Unchained by Peter F Hamilton

Alastair Reynolds - Revelation space i.e. Inhibitor sequence

Peter F Hamilton - Void trilogy in the Commonwealth universe

It's not one of the Culture novels, but The Algebraist by Iain Banks is one of my favorite one book cover to cover operas.

Children Of Time Trilogy.

Amazing books that explore topics like Consciousness and Intelligence from angles you wouldn't expect

Revelation Space.

Niven's Ringworld series

Foundation?

Hitchhikers Guide to the Galaxy 🌌 . Probably not what you’re looking for.

John Scalzi's Old Man's War series was a long and pretty interesting read.

Premise starts out as a "humanity vs the stars" kind of story, but instead of sending young people to their deaths, the futuristic human society instead recruits old people who have already lived full lives. You can enlist towards the end of your natural life to transfer your mind to a (photo)synthetic purpose-built humanoid super soldier body. If you survive a period of time (5 years?), you earn another shot at life and can elect to become a colonist for far away worlds. Most don't get that far.

Your usual "long-term relationship tensions," "humans are always bad guys," "what will technology think of next?" tropes apply.

The Damned trilogy by Alan Dean Foster Hyperion by Dan Simmons The Culture series by Iain M Banks

Have you read any of Alastair Reynolds's books?

House of Suns, while just a single book, felt like it had one of the biggest universes I'd ever read a story set in, and is my favorite sci-fi book, ever.

For something bigger, look into his Revelation Space series. It's a bunch of books, some connected, some not, all set in the same universe.

I really like Neal Asher's books. Sprawling long series (what is the plural of series?) and so good.

Was recommended the Children of Time books, am halfway through the first and WOW. I love it.

If you like Star Wars (original trilogy, that is), I'd recommend Heir to the Empire by Timothy Zahn. I can also recommend his Conquerer's trilogy and Cobra series.

I liked The Lost Fleet, personally. The space battles are excellent, and they're quick reads. Agreed about the plot, though, it takes a while. Worth it overall IMO.

You might consider the Iron Druid series, too. It's written in a lighter tone than the Dresden Files, but it's got a similar vibe.

You might check out Dead Witch Walking by Kim Harrison, too. It's another urban fantasy with an interesting world premise. I struggle a little to recommend it -- I lost interest fairly quickly, but if you don't mind some romance in your urban fantasy, you might like it more than I did. And if you do like it, it's a long series, over a dozen books!

Huge Honor fan here. Have you read Weber's other huge series, Safehold. Not space opera, more like sea opera, but it hits many of the same buttons that Honor does.

Even if you don't think you're into Warhammer 40k you should check out the books. There's 100's of them and are actually very good. I put them off for a long time because i thought they'd just be battle porn. They are well written with compelling narratives, great characters, a sprawling galaxy full of different aliens and factions, and of course the aforementioned war porn.

If you are hesitant like i was, i recommend starting with the first three books in the Horrus Heresy. There's like 40 something of them but the first three you could read and put down satisfied without continuing if you wanted.

I always list the three books out for people because there's so many it's easy to get lost looking for them.

Horrus Rising, False Gods, Galaxy in Flames

As for a non-opera book, I highly recommend Seven Eves. I don't think i saw it in your post. But you had a long list so forgive me if i missed it. It's one book, pretty long though and one of my GOATS.

If you're looking for genuine space opera, I quite enjoyed the Final Architecture series by Adrian Tchaikovsky.

Simon R. Greens Deathstalker series is pretty much what you're describing. Very much space opera, melodramatic and big on action. They're not incredibly well written but lots of fun.

Third vote for Dune!

What? No love for the Pern books by Anne McCaffrey? I love em. Gotta love genetically engineered dragons.

You would typically be the person I would go to for book suggestions, not the other way around.

Sorry I can’t help more :/

How about the Uplift series by David Brin? Start with Sundiver

Have you read Hannu Rajaniemis Jean le Flambeur series?

It's a very high concept narrative, that begins with our main character being broken out of a simulated prison, where he is forced to play endless games of the prisoners dilemma, against endless copies of himself and other prisoners.

It continues on to tell a story set within our solar system, that's complex on levels that can be hard to keep up with at times.

In this universe, where people end and software begins, is blurred, and the same is true for the edge between reality and simulation.

Some people are doomed to exist and be used as mere software for completing complex tasks, while others step through matter-conversion gates between the real and simulated on a regular basis.

I really, really loved it.

Takeshi Kovachs is power fantasy, gary sue, erotica. The universe has an interesting premise, but utterly refuses to explore any of the implications properly.

It's explicitly stated that cortical stacks only record a mind, but cannot run one. But then how exactly does a mind get "written" to a body it didn't originate in? A brain IS its contents, you can't just swap out the harddrive and use the same CPU. A human brain is both storage medium and processor, but this fact is never dealth with. What if the human brain was overriden by a cortical stack running a mind? What if there was always an "original" trapped copy running on that wetware? So much more interesting, but all that potential detail is just handwaved off.

What happens if you install someone into a brain that's damaged? Does that person now have a brain damage related disability while in that body?

And the ever referenced "quellism", some newfangled ultimate ideology for achieving utopia, that is never ever actually explained or explored. And when the creator of that dogma appears, she's little more than a set of genitals for our dear main character to screw.

The best book in the series, is the second, dealing which with the ancient aliens that came before humans, and even in that one Takeshi hypno fingerbangs a woman out of her ptsd. What. The. Fuck. Maybe the netflix series skipping to the third book was for the best.

The Imperial Radch Trilogy by Ann Leckie

The Helliconia trilogy might be worth looking into. It's pretty unique in the genre.. It's not deeply political though if that's what you're looking for. The main character is essentially the planet itself and how the global society of people living on that planet changes over centuries. The seasons on the planet last hundreds of years too so it's adds some interesting evolutionary survival ideas in there.