Hold on a sec while I put on my flame-resistant suit, cuz I'll probably get flamed for this....
Ok, much better. If you can stomach some of the questionable "science", I quite enjoyed Anne McAffrey's "DragonRiders of Pern" series. It's more fantasy than sci-fi, but hey, the stories tend to suck you in. Just stay away from the ones co-written by her son Todd. Her "Talent" series also entertained me (the first 3, the "Pegasus" ones, are the best IMO)
And I'm also a Niven fanboy. His "Known Space" universe is vast and richly textured. On the other hand, there are over 10 collections of short stories and novellas written by other authors but set in Known Space, known collectively as Tales from the Man-Kzin Wars. Quite entertaining. On the gripping hand, he also has some excellent stand-alone novels, such as Footfall, The Mote in God's Eye, and Fallen Angels (others may disagree with the last one, but it's a nice salute to fandom).