strongly agree / agree / ambivalent / disagree / strongly disagree / don’t care whatsoever
I think you're conflating a bunch of things. Dream's plan is not the same as his methodology. His methodology is not the same as his motivations. Having emotional reasons for a plan is not the same thing as that plan being stupid. "lost everything and it's killing me → need a restart" isn't a description of a stupid plan, that's a description of an over-emotional motivation for a plan. Just because you disagree with what his goal was trying to achieve doesn't mean that the strategies he took to achieve that goal were stupid.
Like, take staged finale as an example. I can argue that it's overkill or a poorly considered goal to imprison himself in dangerous circumstances chiefly to achieve a) protecting his close ally b) getting the server off his back and c) getting a sick base. But I won't claim that the steps he took to set up and execute staged finale aren't evidence of someone successfully using strategic thinking to accomplish his goals, which is generally what people are talking about when invoking strategist!Dream.
Dream expecting that his plan will fix his emotional problems isn't stupid in that it's a failure of logic. It's stupid in that it's a failure in identifying that his problems are actually emotional. Which gets covered pretty handily in the genuine finale! Tommy didn't say "your plan is stupid because you neglected to consider these reasons that curing death won't actually work." Instead, Tommy said, "your plan is stupid because you're failing to see that you're hurting people here and now and you could have the friends you want here and now if you just put down your damn book and make peace." which, I'm gonna be honest, also sounds a bit like naive crap to me.
Also, you're acting as if his plan is based simply on an unspecified fear of death when all signs point to it literally being a reaction to the existence of the revival book! Like, sure, when you phrase it like "hur dur maybe this magic book will fix my problems" it sounds pretty stupid. But what actually happened was more along the lines of "permadeath didn't exist on this server as a concept, now it does. revival didn't exist on this server as a concept, now it does. maybe one of these can be used to fix the other." Which is pretty damn straightforward to my eyes!
I really, truly don't see what the problem is with "plan fix death" when you literally have a necromancy book. (Like, logistically, not ethically or whatever.) It seems like the supernatural complications with the balance of life and death, whatever XD's deal is, the server reset, Foolish and the experiments upsetting the balance, all of that, came later (and lacks its conclusion for doylist reasons). but WHY the complaint that fixing death doesn't make sense????? that's like. thing numero uno when you have a damn revival book. sorry if I'm getting carried away but I've seen this argument before and it genuinely makes no sense to me. Reads the same to me as "if you have a hammer and some wood and nails why are you trying to build a table." maybe because I have the tools for the job?
Not to mention that even if we pretended that Dream's only motivation was trying to stop conflict, the plan "learn how to revive people" is still a really obvious solution! Make conflict not have permanent consequences? that's like. an easy mitigating solution.
Also, there's a more general conflation happening here between Dream's unwellness and a more general notion of stupidity. Which I also disagree with. His paranoid spiral led to him locking himself in a prison, but that doesn't mean it was stupid for him to conclude he needed protection, and that his allies needed protection.
The thing with Punz is a separate question, but it's one that I think Punz has answered handily himself: Punz wants knowledge and power, he says so outright, in simple language. He's not indulging a stupid idea: he's in cahoots with a guy who's brought him a ton of knowledge and power. The revive book is real, it's got real results, and it's shown Punz a glimpse of a world he clearly thinks is achievable: a world in which the supernatural shit has indeed been solved. And I don't see why you think he's silly to believe so, given the evidence he's seen with his own eyes.