It really depends on you. Are you a social player or do you enjoy any games solo? Have you played any crafting type games?
I've played mostly solo and I've enjoyed it. Much of the enjoyment of any crafting game solo is figuring things out. If you want to land running and not die and make mistakes then it might not be a good solo game. I don't even look at helps or guides unless something really has me stumped. Do you enjoy figuring out the mechanics of the game and how to survive with them?
If you have a crew of friends I think it could be fun or even a controlled PVP setup. Often on a crafting game multi player ends up being a griefing contest. Plays have done what can be done and all that is left is to mess with other players. I had enjoyed Rust when it first came out but I abandoned it fairly soon because solo was ok but wasn't particularly great. Multi had people with auto weapons killing you when you have a rock.
A plus for Valheim is that you can turn your PVP on or off and protect areas (your base) with a build item. I would guess that due to this you could find MP servers that were enjoyable. I believe there is a discussion with people looking for players.
You could also do a mix. Your player moves between worlds but you could have you solo world and then go do MP worlds.