Hmm... not sure. Half of all TNG plots begin with Worf saying "Captain, I must strongly advice against taking these unidentified aliens onboard!", Picard replying "Overruled Mr. Worf!", and then they find out that Worf was right all along. Picard never apologizes, thus comes off as a prick at times.
“With all due respect sir, I have always felt free to voice my opinions, even when they differ from those of Captain Picard or Commander Riker.” --Worf, when he's getting chewed out by Data
That makes him more real IMO. All humans have flaws of character. That doesn’t mean flawed equls good, we like people who have less of them.