I've lost count of the episodes where we see Riker yell at somebody or something...
With Frame of Mind being the most remarkable....
We have Riker yelling at ARDRA "WE ARE NOT IMPRESSED BY YOUR MAGIC..."
He even yells at poor Lavelle for using two "ayes" instead of one to acknowledge an order (abuse of power, anyone?)
Someone should tell him that yelling makes you rather less convincing than more...
(Kolrami has criticized Riker's inappropriate joviality and lack of seriousness for a commanding officer)
Captain Jean-Luc Picard: Don't confuse style with intent. Only a fool would question Commander Riker's dedication to Starfleet and the men and women under his command. He is simply the finest officer with whom I have ever served.
Sirna Kolrami: We shall see if your faith is well-founded.
Captain Jean-Luc Picard: The test is whether the crew will follow where Commander Riker leads. His... his "joviality" is the means by which he creates that loyalty. And I will match his command style with your statistics anytime.
As far as my observations about Riker are, if you were a new piece of trim aboard 1701-D, then he would flatter you at every opportunity. If you weren't good enough to be a part of Riker's clique (Lt. Barclay, Ensign Lavelle, even Ensign Ro until Riker had his memory erased), then he would treat you like a piece of crap. And it wasn't that Riker was just an ass with subordinates, he was a jerk to "Tom" Riker, non-too-polite to Samuel Clemens, judgmental of Tam Elbrun, and who knows what he actually got up to during
A Matter of Perspective.
I never quite understood what Picard saw in Riker. In reference to the exchange with Kolrami, I'm not sure what joviality to which Picard is referring. Riker is dismissive or demeaning of anyone he doesn't like and as the original poster mentions, frequently yells at people as his mechanism to motivate them. That's not jovial; yelling does not create loyalty. Riker's general attitude and behavior should hardly make him a contender for "finest officer" with whom Picard had ever served.
Captain Jellico saw Riker for what he was: a weak officer who had only managed to reach a position of authority because he lucked into having COs that permitted Riker's narcissism to go unchallenged (Picard, DeSoto).