The more I think about it, the more I actually like it. Its not super successful from a "fan service pay off" perspective. They definitely set some things up and used them more as red herrings than anything else. That's clearly intentional though and not inherently bad.
From an emotional standpoint it works fantastically. Wanda having to sacrifice the family she's created for herself, losing yet another family when that has been the story of her life (first her parents, then Pietro, then the Avengers after Civil War, then Vision, now this new Vision and her kids) is heartbreaking and those final scenes with Vision and the kids are fantastic. Truly excellent stuff. They were more focused on ending this story right than setting things up for future ones (that's what the post credit scenes are for).
I see some people talking about how the line about what she sacrificed is awful, about how she was the bad guy here so it doesn't really work, but I mean... that's the Scarlet Witch! They actually perfectly made her the character she is in the comics, lol. Wanda in the comics is someone who has done awful things. She killed Vision/Hawkeye and ended the Avengers. She destroyed the mutants. She messed up trying to bring them back and only got to do so for a select few. Yet she's still an Avenger at times, she's still sanctimonious, she'll accept some of the responsibility but then she'll wildly swerve into woe is me crap and blaming others for her actions. Its definitely frustrating at times, but if anything they were able to take the character in the MCU and graft her comic persona perfectly onto her.
They also set up a lot of really interesting things going forward. Vision's back, he's alive. He's not really himself though. They're clearly going forward with the white Vision storyline from the comics, where he has his memories, but not his emotions. Where he knows about his past, but he doesn't feel it. He's kind of a new person, but also kind of not. That's going to be interesting. Wanda's kids are still clearly around in some form and will be back, they're going to be Young Avengers. Monica is off to Captain Marvel 2. I'd bet on Jimmy and Darcy showing up somewhere. Agatha is still alive and is clearly hinted to return at some point. Lots of interesting stuff to come.
Also, Wanda's new costume is freaking awesome. Glad they're leaning into it, but also found a way to make what is frankly an absurd looking costume in the comics look cool. I like that as time goes on the MCU has felt more and more free to lean into the more "comic book" elements of it. In the early going they went with a very Ultimate Marvel aesthetic. Not for the personalities or feel of the characters mostly (thank god) but from a look perspective they wanted the same thing Ultimate Marvel did 20 years ago. To be more "realistic" so that people who didn't like the over the top nature of comics would give them a chance. They don't need that anymore though. People are all in and get this stuff enough now that they're cool with it. I dig it.