>>365675794
Asgard's Wrath. It has a ton of cool environments and unique puzzles to work your way through. It actually does offer 40+ hours as it claims without just copypasting stuff or making things pointlessly grindy.

Also, Bean Stalker as of the latest update should more than satisfy you. The progression is open ended, but ultimately you collect, craft, and work your way to getting to the top of each bean stalk to kill all three bosses which should take at least fifteen hours.