Can be anything from any source, movies, books, comics, video games, manga, anime etc.
Pic related is mine, the dragonslayer from berserk. I like it because it's simple. It's just a big fucking sword, no fancy bells and whistles like enchantments or spells.
Second runner-up is sting from lord of the rings, I like that it glows blue when orcs are around and it can be used in the dark as a light source.
There are a lot of contenders, and I guess my favorite is going to depend on various different categories. But the first one that popped into mind just because I think it's really cool is Fromsoft's recurring moonlight sword. Started in King's Field and then carried on into the Souls series and even Armored Core has an equivalent.
I like it because it's a cool design and also has a cool effect. It's the full package, ya know?
An Imgur link was detected in your comment. Here are links to the same location on alternative frontends that protect your privacy.