It's complicated. Different kind of people like different kind of scripts. Some people like the classic standard JRPG fanfare (Final Fantasy and Chrono Trigger), some others the standard WRPG (Ultima), some others like big space operas (Mass Effect), so others like Dark Fantasy (Dragon Age 1 and 2. 3, not so much) and, heck, some other people even preffer dark, depressing scripts with very little hope (Dark Souls and Bloodborne).
My only advice -having no experience in the field of video game scripting, so I might be completely wrong- is that, first and foremost, you need to pick up what kind of GENRE you're going for, what is your target audience/genre fans. With that, all I can say is try to make cahracters to relate to said genre, and do them well. Play a lot of the said genre, see what you like and what other people liked, and use that to your advantage (as long as you don't outright copy). If you go by just "Generic RPG", that's way too vague of a term to start out anything.