How could anyone not like this guy? Oghren helped stop the archdemon, he even helped stop a hurlock broodmother who was subjected to an awakening by The Architect. How does that not make him famous? 
Because when you take the Joining you get knocked out / have visions of some sort. Not to mention right before Oghren took it a guy DIED AT HIS FEET. Oghren was literally taking a gamble of life and death and what does he do? Belches and goes "Is that all"!?
IS THAT ALL?! HELLO! Wake up, ya dumb dwarf! Not only do you have no Stone sense, you have no sense period!
*Breathes*
Aside from Awakening, he was one of the few who had no real goal after all was said and done. His character is all but crippled now, thanks to Awakening, and there's no real point in bringing him back, imo.
It's cool to have characters that you know and love show up, but it gets ridiculous when you play a game and see EVERYBODY again. Not everybody is going to be part of the main story because they have other things to do. It's not all about the current crisis at hand.