@egoraptor Sly Cooper and the Thievius Raccoonus. Not exactly Mario 64 style objectives, but it had levels that you ran into from different hub locations. You grab the collectibles, steal the key at the end of the level, then leave back to the hub area.
I could see Sony try to make their own animal crossing/Pokopia game but with astrobot and all of the villagers are astrobot versions of PlayStation characters.