I hate the new behavior. The great thing about the Memories feature was that it helped discover old photos and awaken memories. The mandatory addition of music is cloying and obnoxious. It tries to force a mood, rather than letting a mood emerge. This is particularly true when the photos are of dead people and pets. The times depicted may have been good, and revisiting them is welcome, but they are also, often, bittersweet. I want to feel MY feelings, rather than having some AI chosen music trying to drag me in a different direction.
I imagine some people like it. I might even choose to try out Apple's musical selections, but I don't want it forced on me. Right now I still have the memories widget on my home screen. I still appreciate seeing photos, but I'm also frustrated and traumatized because I know that if I heed my desire to click through I'll be irritated by the unwelcome music.
I've submitted feedback about this on Apple's site. I hope others do the same, since the people who made product decisions don't routinely read things here.