One could pick a worse role model than Picard.
WWPD?
Yeah, that was half my point. I probably phrased it poorly, but what I mean is if we accept his faults are idealism and pragmatism, we can then suggest his faults will not transfer. It's really hard to be that pragmatic IRL!
I bet there is a strong correlation between Data (the character) and a programmer.
What do you think the correlation to Riker, Picard, Worf would be?
seems a tad cliched, don't you think? i'd bet that most people wouldn't want to self-associate with an emotionless android
Contrast to TOS where Spock was a fully developed character and an equal participant in the Kirk-McCoy-Spock trinity.
Although, I do really like your comparison to Scooby Doo and Scrappy.
Words to live by.