awww yeah. space opera!
I always recommend Dune if you haven't read it yet.
Also I'm reading the Bobiverse series at the moment. It's 3 books (The third was just released).
It's about a guy who dies in this century and gets revived in the future as an AI, to be trained for the purpose of piloting space faring ships. the whole series is about him exploring the universe with copies of himself.
it's super nerdy and a bit light hearted in tone.
If you want a more serious tone, I'd also suggest the culture series by Iain M banks. most of the books are standalone stories set in the same universe. I'd start with perhaps player of games.
And for epic insane serious level, there's always the foundation series by Asimov. I couldn't get through it personally. It was like reading about an entire different universe. Scaling over centuries of time.