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.
Gotta read these books.
Pratchett was insanely good at mixing the real and fantastical in both deeply meaningful and very witty ways. There is a reading order of sorts, but you can dive in at just about any book and work out the actual timeline later without ruining the experience.
there are torrent packs out there for both the books and the audiobooks. after another user mentioned it here i've been using the audiobooks to sleep to.