I'm tired of all of the 'Great Man' type stories where a single individual or group changes the fate of the galaxy. Consider Phlebas by Ian Banks did it in an interesting way, the payoff of the heroic actions and sacrifice of the characters was revealed to be unimportant in the grand scheme of the war being fought, but this isn't revealed until the end, so it was a bit of a gimmicky 'gotcha' moment.
I want more slice-of-life sci-fi and fantasy. I recently read Long way to a Small, Angry Planet by Rebecca Chambers and really enjoyed the vignette based storytelling centered on a working class crew. You got to explore interesting corners of the galaxy a la Star Trek, but without the high stakes.
I also just finished reading Semiosis by Sue Burke, a humans-settle-an-exoplanet type story, and one of the things I really enjoyed was how the story was told in generations. It allowed for a cool materialist(?) storytelling where you could see how the culture of their 30-100 person colony is shaped by historical events that you just read about the chapter before.