There's a visual novel called 'Fate's Twist' where a guy loses his arm due to a magical curse. The curse was cast by an evil sorcerer and has a significant impact on the character's journey and development throughout the story.
The way Oliver Queen loses his arm in comics isn't always the same. Sometimes it's a result of a risky mission gone wrong, or it could be from a confrontation with a villain with unique abilities. It all depends on the particular comic storyline.
Misty Knight loses her arm in a rather tragic incident. She gets caught in a dangerous confrontation where she underestimates the enemy's power and pays a heavy price.
In some fanfictions, Natsu might lose an arm in a powerful battle during the Grand Magic Games. Maybe he overestimates his strength while facing a super - strong enemy and in a moment of distraction or miscalculation, the enemy lands a fatal blow on his arm, severing it.
The novel I recommend to you is " Hong Kong Reborn: Entertainment Tycoon ". The novel told the story of a Chinese journalist who died on a mission and was reborn. His soul traveled to Hong Kong in 1985 and became the protagonist named Li Yangshu. In this story, Li Yangshu looked at the familiar streets and characters in Hong Kong movies and shouted excitedly," Xiangjiang, I came, I saw, I love." The main character in this novel has started to lose his arm, which might meet your needs.