Yes, there are likely 'Bardock Kills Frieza' fanfics out there. The Dragon Ball universe has a huge fan base, and many fans like to create alternative storylines. You can try searching on fanfic websites like FanFiction.net or Archive of Our Own.
The plot could start with Bardock having a premonition of Frieza's future actions against the Saiyans even before the destruction of Planet Vegeta. He then secretly trains and discovers a new form or power that allows him to stand up to Frieza. When Frieza arrives to destroy the Saiyans, Bardock reveals his newfound strength and battles Frieza. After a long and intense fight, Bardock manages to defeat and kill Frieza, changing the course of the Dragon Ball universe. This could also lead to new alliances and power struggles among the remaining characters.
There are fanfictions where Vegeta has a spiritual awakening of some sort. He realizes his true potential and his connection to the Saiyan pride. This newfound power allows him to generate a massive energy field around Frieza. The energy field then compresses in on Frieza, crushing him from all sides until he is completely destroyed. This method not only shows Vegeta's power but also his growth on a more spiritual level.
I haven't actually read this specific 'piccolo and gohan lemon fanfiction', but generally, in fanfictions involving these two characters, it might explore their relationship in unique ways. It could be about their friendship evolving, or perhaps their teamwork in new and unimagined scenarios within the Dragon Ball universe.
Frieza might initially be shocked. He's used to being a feared and powerful being, and the idea of having a family is very foreign to him. So he could be in denial at first.
For Yamcha, you can focus on his growth from being a bit of a comical character to a more serious and respected fighter in the context of his relationship with Frieza. Maybe he learns from Frieza's cold and calculating nature how to better strategize in battles. For Frieza, his development could be about him learning to care for someone other than himself. He could start to see Yamcha as an equal, which is a huge shift from his usual superiority complex.
A major theme is identity. Since she is a female version of Piccolo, she has to come to terms with who she is compared to the original Piccolo. Family also plays a role. In some fanfictions, she might be searching for her family or creating a new family of her own. Additionally, the theme of good vs. evil is common, as she battles against various villains.
I'm not that familiar with the specific 'Brian Piccolo Thanksgiving Day story'. Maybe it could be about how he spent the Thanksgiving Day with his family, sharing a big meal and giving thanks. It might also involve some special traditions he had on that day.