L's death in the manga occurs as a result of Light's elaborate schemes. Light finds a way to trick L and eliminate him, marking a significant turning point in the story.
Light dies when his name is written in the Death Note by Ryuk. Ryuk, who was the shinigami that gave Light the Death Note, decided to end it as per the rules.
Definitely. Fanfiction.net is also a great place to search for Death Note female L fanfictions. The great thing about fanfictions is that different authors can put their own spin on the character. In some of these fanfictions, a female L might have different personality traits compared to the original male L. For example, she could be more empathetic in some interpretations, which can lead to very interesting storylines.
There's also 'L and Misa: A Different Perspective'. This fanfic delves deep into their characters. It explores how Misa's adoration for Light affects her relationship with L. It's really interesting to see how L tries to understand Misa's motives and how she might be a key in his investigation.