It’s fun single player by default. That said, you can also mod it to be however much of a grindfest as you want.

The Valheim Plus mod let’s you change virtually any modifier for drops, exp gain, etc. It has a granular config file that has everything disabled by default, allowing you to enable only what you want.