Atelier series is the closest one to this that I can remember. You have exploration part where you find resources from resource spawn spots or farm enemies. Then you have crafting part which is different in each game of the series where you do some puzzles to craft items. It's easy to craft simple items, but much harder if you need an item with certain traits and higher quality. Some new maps become available when you get new tools, like a bomb for blowing up rocks which are blocking your way.

Atelier series is such a good game too.
I like to try and solo the games with no party members, it is hard yet fun.
(The game is not made to do that) xD