I know I'm in the minority, but I don't think Riker turning down promotion was a bad thing. During the scene with Troi in Best of Both Worlds Pt 1 where Riker is complaining that he's lost his drive and ambition, she thinks he hasn't lost a thing but he's grown, he's more comfortable with himself and happier than she's ever known him to be. I think that's the point, there's more to life than ambition and your career and now Riker's found a place for himself on the Enterprise where he's happy he doesn't want to give that up. I don't think that's a bad thing.