I loved the story type console games alot, I played all but castaway. I did play castaway on pc though along with the other Sims stories games. I love that we have the OG pc game on console though too. The Sims 3 on console was similar to the pc game if not in some ways slightly better gameplay wise with the karma powers and the ability to upgrade town buildings and the Sims 4 is handy to have on console, I never play it on my pc anymore. I think I wouldn't mind a Sims game that has either both a story mode and also normal sandbox gameplay or just a main game and then spin offs. I know that some of the console games allowed you to play sandbox as well as having a story.
