One idea could be that the characters from Arrow get transported to the Supernatural universe. Oliver Queen could team up with the Winchesters to hunt a demon that has somehow made its way into Star City. Maybe the demon is using some of the technology in Star City to create chaos, and they have to combine their skills - Oliver's archery and combat skills with the Winchesters' knowledge of the supernatural - to stop it.
Another plot could involve a supernatural event in the Arrowverse that only the Winchesters can help with. For example, a powerful witch from the Supernatural world has cast a spell that is affecting the minds of the people in Star City. The Arrow team tries to stop it on their own at first but realizes they need the expertise of Sam and Dean. Together, they figure out how to break the spell and in the process, share their different ways of dealing with threats.
A cross - over could involve a curse in the 'Arrow' world that has a supernatural origin. Oliver Queen and his team seek the help of Sam and Dean Winchester who are experts in dealing with the supernatural. Along the way, there are clashes in their methods of operation but they gradually learn to trust each other and combine their skills to break the curse.
A cool plot could be a time - travel crossover. The 'Supernatural' crew travels to a time when Star City was in its early days. They meet a young Oliver Queen and end up changing some events that have a ripple effect on both their universes. This could lead to new alliances and new enemies. Also, a powerful witch from 'Supernatural' could put a spell on Star City that only the combined efforts of the two groups can break.
One idea could be that the Flash and Arrow team up to stop a meta - human who has the ability to control time. They have to race against the clock (literally) to figure out how to neutralize the villain's powers before he rewrites history in a way that destroys Central City and Starling City.
Well, a great plot for Supergirl Arrow crossover fanfiction could be centered around a common enemy from another dimension. This enemy has technology that nullifies Supergirl's powers and Arrow's skills, so they have to rely on their wits and each other's unique strengths. For example, Supergirl could use her heat vision in a creative way to expose the enemy's weaknesses while Arrow uses his archery skills to set up distractions. They could also meet some interesting characters from the other dimension during their adventure.
One idea could be that Batman and Arrow team up to take on a common enemy like Ra's al Ghul. Since both of them have had run - ins with him in their respective storylines, it would be cool to see them combine their skills and resources to fight against him. Another plot could involve a mystery that spans both Gotham and Star City. Maybe there's a new criminal organization that's using technology from both cities to carry out their evil plans, and Batman and Arrow have to figure out how to stop them while also dealing with the differences in their methods of crime - fighting.
One idea could be that an alien threat emerges which requires the skills of both Arrow's team in Star City and Supergirl in National City. They have to combine their combat styles, with Arrow's more grounded and stealthy approach and Supergirl's super - powered attacks. For example, Arrow could use his trick arrows to create distractions while Supergirl takes on the stronger alien foes directly.
A great plot could involve the two heroes swapping cities for a while. Arrow tries to deal with Gotham's crime underworld while Batman goes to Starling City to investigate a series of strange disappearances that might be linked to a powerful criminal organization there. This would lead to both heroes having to adapt to different environments and crime - fighting styles.
One idea could be that the characters from Torchwood and Arrow team up to fight a common enemy that has some sort of interdimensional powers. Maybe a villain from Arrow's world has found a way to access Torchwood's technology and is using it for evil, and the two groups have to combine their skills to stop it.
One idea could be that a powerful villain threatens both Star City and National City simultaneously. Arrow and his team are struggling with the more street - level threats in Star City, while Supergirl is dealing with the super - powered aspects in National City. Eventually, they cross paths when the villain's plan connects the two cities. For example, the villain might be using some sort of technology that is affecting the meta - humans in National City and also causing chaos in Star City's criminal underworld.
Maybe there's a meta - human or a super - villain who is causing chaos in both cities. Batman is too occupied with Gotham's internal affairs, so Arrow comes to help. They discover that the villain has a base in an abandoned area between the two cities. They have to combine their resources, like Arrow's high - tech arrows and Batman's detective skills (even if Batman himself isn't directly involved but his influence on Gotham's crime - fighting is there), to take down the bad guy.