I tend to think the moon has effects, but I wouldn’t necessarily label them “negative” per se.
The moon certainly has some effects – it changes the light levels and gets people’s attention when it’s not entirely blocked by clouds. And it is certainly true that many people think it has various effects. Many people who deal with the public and work at night say that they see more crazy behavior around a full moon.
Even if I were to completely buy the skeptical arguments against it*, I would still have to note the above as actual things, and say that that will have effects on behavior. If anyone rejects that, I’m liable to develop a bias against their thinking as rabid skeptics, because it’s just clearly entirely true. But it’s not a black and white simple effect like only more crazy or entirely negative – humans aren’t that simple.
(* Registered skeptics put out some of the most unscientific argumentative junk reasoning – the main distinction being that they try to dress it up as science, and that they actively hunt down other ideas to shut down open-minded exploration of certain types.)
And, since I know many very smart and sanely-skeptical people who are interested in such things to some (or to a very great) degree, who would say so, in addition to what I wrote above, I would say, from anecdotal evidence and the agreement of sensitive smart spiritually-oriented people I know, as well as sensitive smart non-spiritual but non-uber-skeptical people I know, that ya the moon can have effects on people’s and animals’ way of being.