One interesting fanfiction could be about the reactions of the human side when a new and unexpected god shows up to fight. For example, how they strategize and what their initial thoughts are.
You can start by looking on fanfiction websites like Archive of Our Own (AO3). It has a large collection of fanfictions from various fandoms, including Record of Ragnarok. Just search for'record of ragnarok reaction' and you'll likely find some good ones.