A castaway story would be fun but it would have to be implemented differently than the original just because of how the Sims 4 is played. You shouldn't/couldn't really be stuck on the island, so instead give the island a mystery to solve (a curse, buried treasure, etc.). Then provide everything you would need to pretend you are stuck on the island so that players could choose to live on the island as if stuck or just come and visit the island to solve the mystery. It would better satisfy both the sandbox and story driven players I think.
Things that weren't in the poll that could be fun with stories:
Superheroes - Each level of the story would be the super villain slowly implementing their plan to take over the world/city and you have to stop them before it's too late. The first level the sky would darken with random lightening strikes, second level would be random earthquakes on the lot you are at, third level everyone would be angry and fighting in the streets and/or henchman would be around starting fights or freezing sims with freeze guns. At the end you have to destroy the villain's takeoverthecityinator which is causing all these things.
A fairy forest - A wood which at first appears normal, but as you explore it becomes more and more apparent that the fairies are displeased with your poking around. Each stage would increase the magical feel of the woods (fairy lights, glowing mushroom circles, a glow to the sky). At the end you could make a deal with the fairies to return everything back to normal or leave it as is. If you have high mischief you could trick them (beware their wrath) or with high charisma you could befriend them (beware their friendship).
Basically I think the life states which are less likely to get a pack dedicated to them, could be brought into the game by tying a story to them. I could see something similar for mermaids and a treasure hunting story line, could even throw them into a castaway story.
