Ooh...
I have so many good books and series I could pass on.
First of all let's start with sci-fi.
Neal Asher is one of my all time favorites. He writes sci-fi in a style I would sum in one word as 'brutal'
It's both massively cinematic in scope, and cozy. The characters and setting feel extremely real, even as they deal with life in his vivid setting.
Some favorite quotes. (Both are from beginning of chapters, this not actual narrative.)
"A Contraterrene device is a bunker buster bomb resembling nothing so much as large thermos. However if you were open this one, you would find antimatter,briefly."
"With seven previously known civilizations with technological prowess beyond our knowledge, and with the inevitable march of Moore's laws past the atomic level, it almost certain we are surrounded by relics of aeons past. And that somewhere, on some once dead world, the machinery in a grain of dust will spring to life, charged by the heat of passing probe, and our world will change forever."
I can recommend Prador Moon as good first book.
Another good one is the Empress of Mars by Kage Baker.
A story about what happens when the colonization of Mars is abandoned as unprofitable, and the strange society that happens with the people left there, with no way to earn enough money to make it home. That situiation changes pretty quickly.
I must confess its a rather vague recomendation, but do read the Years Best Science fiction and Fantasy. I find the short stories in there jaw dropping, and i kept having to think of actual novel length stories when i set out to make recommendations.
In terms of Fantasy, one of my all time favorites is Jane Lindskold, in particular her Firekeeper series.
The first book is "Through Wolve's Eyes." And though it doesn't have much outright magic in it, it is strong tale featuring a woman raised by wolves being thrust into the middle of politics as the realm teeters towards a war of succession. Later books have more magic and fantasy in them, but they are all really about the characters and plots between them instead of the rise of some dark lord or another.
A graphic series i can recommend is Linda Medley's Castle Waiting series. Beautiful woodcut style illustrations and a story about people, making ends meet. No obvious heroes or ancient quests, just people getting along as best they can. Includes Doctor Fell, an obscure character from a nursery rhyme. Oh, and Beaky and Chess, one of my favorite duos.
Spoiler: An example page show