Speaking of doubles, are there any episodes with a bizarro-Picard? As in it's legitimately Picard but this one's got a New Jersey accent, a beer gut and he's impolite and chauvinist and generally negligent in command, flouting the PD, etc. Time-travel Picard was cool but I want a polar opposite version.
You are in for a treat! Watch TNG s6e15 "Tapestry" wherein Picard gets a visit from Q to re-live a pivotal decision from his past. I'll try not to spoil too much, but suffice to say, this is basically the result: