Well, in the regular 'Family Guy' episodes, Connie is just one of the side characters with a somewhat limited role. But in a fanfic, especially a 'lemon' one, she could be the central focus. Her character might be developed more deeply, with more backstory and personal growth arcs.
One memorable classic story is the one where Stewie tries to take over the world. It's really funny to see his elaborate plans and how they always seem to go wrong in the most hilarious ways.
Often, 'Family Guy' uses classic novels for comical parodies. For example, if it's referencing 'The Scarlet Letter', it might make fun of the idea of public shaming in a modern, absurd context. It takes the key elements of the classic novels and twists them to fit its irreverent style.
One popular 'white guy time travel fiction' is 'A Connecticut Yankee in King Arthur's Court' by Mark Twain. The story follows a Yankee engineer who is transported back to the time of King Arthur. It's a humorous take on the contrast between modern and medieval values.
Time travel can have a profound impact on family love. Imagine a person travels to the future and sees their family in a difficult situation. They come back with a sense of urgency to change things in the present to prevent that future from happening. This act of trying to protect the family can enhance the love. On the other hand, if time travel is misused, like if a family member uses it to avoid family responsibilities in the present by escaping to another time, it can damage the family love.
One common theme is the fish - out - of - water situation. For example, in 'A Connecticut Yankee in King Arthur's Court', the modern man has to deal with the very different customs and beliefs of the Arthurian era. Another theme is often the idea of changing history. In 'The Time Machine', the traveler observes how the future has deviated from his expectations, and there's an underlying question of whether he could or should interfere with the course of time.
I don't think I've heard of an episode specifically titled 'Family Guy Canadian Horror Story'. However, Family Guy often does episodes that involve travel and horror - like elements, so it's possible that it could be a fan - named or proposed episode idea rather than an official one.