Well, the allure lies in the unique combination of two very powerful and distinct identities. The Dragonborn is already a sort of chosen one with great power, and adding the vampire element just amps up the cool factor. It can create stories full of moral dilemmas, like whether to embrace the vampiric side for more power or resist it to stay 'good'.
Well, 'Blood and Shadows' is a well - written Skyrim vampire fanfic. It has an interesting plot that involves a vampire trying to navigate the complex politics of Skyrim while hiding his true nature. Then there's 'Midnight's Vampire' which has a really engaging main character. This vampire is different from the usual stereotypes and has his own unique backstory and goals. And don't forget about 'Vampire's Alliance' which shows how vampires can form alliances with other races in Skyrim for mutual benefit.
One great fanfiction idea could be the Dragonborn Vampire Lord's struggle to maintain his humanity while dealing with the thirst for blood. He might have to make tough choices between using his vampiric powers for good or succumbing to the dark desires that come with being a Vampire Lord.
One great fanfiction idea could be a Vampire Dragonborn who struggles to control their bloodlust while on a quest to save Skyrim. They might face unique challenges as both a vampire and a Dragonborn, like being shunned by some townsfolk but still having to use their dragon powers to defeat powerful foes.
His Sharingan - if he had it in this godlike state - would allow him to see through illusions in Skyrim. Many of the mages in Skyrim use illusions to deceive their opponents. Naruto could easily counter that. Also, his chakra control could be used to enhance his weapon handling in Skyrim. He could infuse his chakra into a sword or an axe, making it more powerful and able to cut through tougher enemies.
Another place could be FanFiction.net. There are many Skyrim - related fanfictions there as well. However, the quality and content can vary widely, so you may need to sift through some stories to find the ones that interest you. Look for the sections related to Skyrim and then narrow down your search to vampire - themed ones.
One interesting Skyrim vampire fanfiction could be about a vampire's struggle to resist their bloodlust in the world of Skyrim while also falling in love with a mortal. Maybe they try to protect the mortal from other vampires or the perils of the land.
The theme of isolation is also quite prevalent. In Skyrim, being a vampire is not always accepted, and as a dragonborn, they are set apart already. So, they often face loneliness. Also, redemption is a theme in some fanfictions. The vampire dragonborn may try to atone for their vampiric deeds while still using their powers for good in Skyrim.
A plot could center around the Dragonborn Vampire Lord's search for a cure. He might hear rumors of a powerful artifact or a wise mage who can reverse his vampirism. Along the way, he meets other vampires who either try to persuade him to embrace his new life or are jealous of his power. He also has to deal with the normal threats in Skyrim like dragons and bandits while trying to keep his vampiric nature a secret from those who would hunt him.
One common theme is the struggle between vampiric nature and humanity. The OC vampire assassin often has to deal with their bloodlust and how it affects their actions and relationships. Another theme is the use of stealth and assassination skills in the Skyrim world. They have to be sneaky to survive and complete their missions.