He drove a wierd buggy-car in ST: Nemesis,
And was turned into a Borgling at some point. He has a pet lionfish, and was born someplace in California. Among his crew are an android Data, a slightly telepathic Counsellor, Deanna Troi, and a dude with a mustache, First Officer Riker. He likes to order "Tea. Earl Grey. Hot" from the replicator (personally, I think someone who gets into battles every other episode, and has lost multiple Enterprises should have something a bit stronger to drink).
He has a couple of old, paper-bound books, and Violates the Prime Directive on occasion. And, IIRC, his ship's designation was NCC 1701 -D or E or something similar.
Replicator *delivers iced latte*
Picard : OMGWTFBBQ!!! Geordi! Get down here!
***loosely paraphrased from short story***