I think the problem with Riker's depiction, both in this episode and in general, is that he's been forced to bend to the whims of the plot.
We hear, in Season One at least, about how ambitious and driven he is, and how he rose through the ranks. And the ambitious thing gets repeated throughout the series.
But he doesn't leave. For someone described as ambitious and driven, being an XO under the same guy for 14 years or so (2364-2379) seems odd, especially when being offered command of three different starships during as many seasons of the show:
U.S.S Drake NCC-20381 in 2364
U.S.S Aries NCC-45167 in 2365
U.S.S Melbourne NCC-62043 in 2366
He turns them all down. He doesn't want the Drake, because a better offer came along (presumably the XO position on the Enterprise-D). Admittedly, the Drake doesn't sound like a ship I'd want either.
He doesn't want the Aries because of the "distinction" he got as being the XO on the Enterprise-D, for, as he said, "self-interest". So, instead of being in charge of his own starship, instead of being the ambitious officer he was (and still is) described as...he stays.
He ultimately doesn't get the chance to accept or turn down command of the Melbourne, since Picard gets captured, he gets field-promoted, and it gets destroyed at Wolf 359. But a good portion of Best of Both Worlds is taken up by his wondering about his future, and why he remains. And, after having been part of the successful effort to defeat the Borg cube, and in light of his previous accomplishments, we hear that he would probably be offered any starship command he wanted, especially since Starfleet would need as many experienced officers to help fill the gap left by the 39 starships and 11,000 lost. Instead, he stays as Enterprise XO.
This is the last time, from TNG up to VOY, that we hear of Riker being offered a command.
In the episode Death Wish, which takes place in 2372, Q (John de Lancie's Q, not the other Q in this episode) mentions that he had thought Riker would have taken command of Voyager, so it's possible that he was offered it and turned it down as well.
And then there's nothing until 2379 and Nemesis, where Riker finally takes command of a starship, namely the U.S.S Titan NCC-80102. While there's no canonical explanation, in the A Time to... novel series, Admiral Janeway contacts Riker and says that he's being offered the Titan, and that he can expect nothing further from Starfleet Command if he turns it down. After finally being cornered, and in light of some intense personal and familial conflicts, he accepts.
Getting back to the point I originally raised, Riker, like many of the characters, suffered from both the vagaries of plot, and the need to have continuity amongst the cast, even if it wasn't very realistic, and conflicted with what has been said of the character or characters.