I'm so torn on DCA. I think the park thematically peaked in 2015 (when Soarin' still soared over California, and Grizzly Peak took over Condor Flats), but I do find Mission Breakout to be ridiculously fun. I'd never even seen a Marvel movie before riding, but it immediately won me over.
Avengers Campus is also pretty lame on the surface, but the character experiences and interactions are better than anywhere else. They're what Galaxy's Edge should have had.
Pixar Pier was completely unnecessary, but the coaster remains a great coaster, and I do get some joy out of the irreverent jokes in the queue (i.e. Violet speaking for all the fans regarding the overhaul, and Edna justifying the move as "synergy"). I also enjoy the soundtrack more, if only the characters weren't constantly chattering over it.
The core of the park is Buena Vista Street, Grizzly Peak, and Cars Land, which remains a really solid core.
Overall, I find DCA to be a solid compliment to Disneyland, and I'd take its headliner attractions over Epcot's. It's hard to place these two, with only World Showcase giving Epcot a fighting chance, IMO.
It's been a few years (5-6) since I rode Spider-Man, and frankly it wasn't my favorite either. That said, it's far more ambitious than Ratatouille and employs more motion with the ride vehicle, which makes a difference. With Ratatouille, the vehicle can do almost anything ground-based, and for whatever reason you spend way too long sitting motionless and staring at screens. Screens that don't convince you you're in that world, either. The oversized props look like oversized props, and overall it really fell flat for me.
Would love to ride it again and see if 7 years of resigned disappointment make it better, but I have my doubts.