Book reader community.
While i havent finished them, i really enjoyed going through the Battletech novels.
Big stompy robots in a galaxy spanning civilization with a nice long history. The books take place over a few generations so as you read you get interested in the events from previous books by different factions in universe. I also like that there are a variety of authors so you dont get fatigued by a single style.(at least that was my experience)
Lots of intrigue and conflict with enduring characters.
Look at expeditionary force series. Pretty fun series.
The best book I've ever read is The One Hundred Year Old Man Who Climbed Out Of A Window And Disappeared
Deepgate Codex by Alan Campbell.
It's 3 books: Scar Night, Iron Angel, and God of Clocks.
If you're looking for something longer, try Brandon Sanderson's cosmere (start with either Mistborn or Stormlight Archives.)
Or perhaps Jim Butcher's Dresden Files (hard-boiled detective who also happens to be a wizard.) First few books are a bit weak, but gets much better.
Some other ideas:
Murderbot Diaries, The Locked Tomb, Assasin's Apprentice, Broken Earth, Kings of the Wyld.
If you enjoyed the mystery part of the expanse I recommend Beacon 23.
Sounds like you have a lot in common with my father's reading tastes. In which case, I will recommend the Thursday Next series by Jasper Fforde.
Seconded, for the nefarious villain Jack Schitt
The Stone and the Flute by Hans Bemmann
One of the most profound set of allegories I've ever read.
If you like DnD type stuff, He Who Fights With Monsters is about a dude who wakes up in an alternate universe where magic is real. It's pretty great, and 10 books deep.
Spiral Wars series by Joel Shepherd.
Bit more action-adventure based, but good fun read with good characters and worldbuilding.
Neal Stephenson has a few good SF books (seveneves comes to mind) and some good alt history (cryptonomicon).
I just finished re-reading the three body problem series and it's still good too.
You like many of the same books that I like. Try the Red Rising series by Pierce Brown. I just read it recently and now itβs one of my favorites.
For sci-fi, one I haven't seen mentioned here yet is Red Rising.
Kind of an Enders Game meets Hunger Games in the first book, but quickly expands into a solar-system wide war with lots of intrigue, star-wars-like tech, and amazing characters.
The Long Way to a Small, Angry Planet by Becky Chambers, if you want another addition to the Sci-Fi theme.
Can also second some books others have mentioned, like Dune (one of my all-time favorites) and Three Body Problem (for a recent one I liked, although it was a bit "rough" in terms of style and storytelling).