I spent an embarrassing amount of time playing The Sims 2 on DS, for starters it isn't the usual life sim that the Sims is known for, rather, it's this weird adventure/management game hybrid where you're the manager of a hotel and have to keep your guests happy while also exploring Strangetown while trying to find ways to make more Simoleons. Eventually you could upgrade your hotel to have a casino and a "Ratcave" where you get a "ratsuit" that lets you attack the numerous threats that attack the town at some point (I'm just going off the top of my head here).
Also, if you turned your clock forward to cheat the money system, aliens invade the town.
The mobile versions of The Sims games are all really interesting like this. All of The Urbz games were a departure from typical Sims titles, but the GBA version was a strange social adventure game centered around different rep groups (essentially cliques or gangs). It had a lot of charming dialogue imo.
To me these games capture the books amazingly well. They're willing to depart from the movies and add stuff that was only in the books, like the Deathday Party in Chamber. They also play like dumbed-down Final Fantasy games.I think the Game Boy versions of the early Harry Potter tie-in games were also pretty much 2D RPGs
The Harry Potter games in general are interesting cases in that there were pretty pronounced differences between the editions. Like the versions of Chamber of Secrets on the GBC, PS1, and PS2 are all completely different games.