+1 for the monster hunter games, everything is crafted from monsters you hunt and there are tons of ways to customize your gameplay based on your play style and what you craft.

The Etrian Odyssey series also bases what you can craft on what you can find, but crafting is less in-depth than MH. That said, you also make all the maps which is a huge bonus in my book

This is a stretch because it's an ARPG, but Path of Exile 2 is all about chasing after gear and crafting (or you can buy from other players.) The crafting is very deep with many different ways to modify items, but it does rely on good RNG.

Some other options are the rune factory games, specifically Rune Factory 4. I really enjoyed its crafting system, and for the most part you can ignore the farm life in that game and just go through the dungeons/explore.

Legend of Mana is another option, and pretty much any of the Monster Hunter games (Rise is my personal favorite.)

Fallout 4 maybe? The main gameplay loop is gathering junk to get parts to improve your equipment.

RuneScape maybe?