I went into this before, but I think it's worth saying again since I'm such a fan of AC music across the board.
New Horizons' hourly music is so... bland and lifeless. Other than a choice few songs they all run together and fail to stand out. It wants so badly to give off that relaxed vibe with a mix of plucky beats and that tropical island ambiance but instead it just comes off as samey and boring, sometimes even annoying. I personally am not a fan of the fan-favorite 5PM, the way it honks and squeaks just ruins any merit the drums and bass have. People claim so hard that is slaps and I'm just like... are we listening to the same song? It grates on my ears like crazy.
6PM I feel is the best hourly song, the accordion is so distinctly Animal Crossing, it is a truly relaxing and pleasant tune in a sea of uninteresting, irritating noise.
I don't think all Animal Crossing songs need to be moody or nostalgic, but it needs to have character. I wanna feel a way, whether I feel chill, happy, energized, just... anything, please. The GCN soundtrack and New Leaf's soundtrack are my personal favorites because it feels like there's a clear vision there.