I haven’t played it myself, but Boku no Natsuyasumi is a game that recently entered my radar, which fits your description quite well. It’s a game I want to play sometime, but I have had other priorities. It’s for PSX.
It’s about a boy in a summer vacation with his family.
Unfortunately there doesn’t seem to be any official English versions of the game, but hopefully you might find a solution if you think the game looks interesting enough to play it.