that is the only thing that ever bugged me about the otherwise magnificent "Tapestry" - Q turning Picard into a junior grade science lieutenant was played as though those people have pitiable existences and just rubbed the wrong way.
This made me wonder - suppose any character from Trek was given the "Tapestry" treatment by Q. What pivotal time in their lives, previously mentioned in the series or not, would they be returned to? What choice would they make? How would it change their lives for the better or worse?