The Avi Arad hate is overrated. There are worse producers out there. His mistakes are just more high profile. Guy has definitely made some bad moves in hindsight, and I have no idea if he's completely involved with some of these bad talents being chosen to direct and write these awful Spider-Man spin-offs (Why was Venom's writer promoted to director for the latest film?). Avi Arad is also the producer of two of the best Spider-Man cartoons (90's animated series, and Spectacular Spider-Man), and was the guy who believed in a theatrical animated Spider-Man movie (which many laughed at), which he got Miller and Lord on whom proposed using Miles as the star, which Avi agreed. Avi wasn't wrong about Venom's appeal, but he compromised with a director who didn't understand the character with Spider-Man 3, because he was overtly driven by scale, and audience demand, but the talent wasn't there to deliver. Avi is largely a marketer. He would not accept Spider-Man joining the MCU unless Spider-Man was the lead character. He does follow trends too much, and ends up putting out product that's behind the times, and while I completely agree with him that a independent Spider-Man universe can work, it's completely botched by the bad creative's involved, and besides Venom and Kraven, Morbius and Madame Webb are bottom of the rug/least exciting characters you can pull from that verse. They botched the Carnage juggernaut, which should've been saved as a character for a huge event. I don't like the alternate Spider-Man's very much, but the Spider-verse movies were well received, so I think it's only a matter of 'when' for Miles Morales and Spider-Gwen to have their live-action debuts. Eww! Spider-Man eventually teaming up with his enemies makes a lot of sense to me, as we're talking about the Parker luck here (that doesn't seem to exist anymore), so I was all for Villain spin-offs over Avengers cameos, but Sony don't got the chops to put out anything special, and these Villains/Anti-Heroes are just basically acting like heroes in these spin-offs... like c'mon!
Also, I think Avi got a shout-out at the end of No Way Home because the Sony leaks had people laughing at his idea of bringing back Tobey Spider-Man in Andrew Garfield's led Amazing Spider-Man films (any comic reader knows how stupid comic book stories are, so I wasn't laughing). Lo and behold, the most successful Spider-Man movies is No Way Home, which brings all three live-action Spider-Men together on screen. I watched it too, even though I thought the film was garbage. xD It probably would've been a huge hit even without Dr. Strange/Marvel, but hey, who knows how effective these twitter campaigns are that were originally crying about Spidey leaving the MCU after Far from Home. They did largely drive up the hype for the No Way Home Cameos after all.
Lord and Miller are also producing their own Spider-Man live-action universe for streaming/TV, though they are having a heck of a time getting even one project out the door. The first release appeared to be Silk: Spider Society, but it's hitting bumps left and right, and Spider-Man Noir got it's Nicholas Cage announcement, but we'll see how long until it actually finds its way onto streaming platforms. Doesn't sound like it's anytime soon.
Anyway....
I'm neutral with Zelda. It can go either way. Miyamoto is a producer too, and he will have his say. The quality of the movie will largely fall on Wes Ball, and the writing team to conjure a compelling story in a universe we are all familiar with, with Miyamoto making sure the film stays faithful to the Zelda brand, with a creative input or two. I think Avi is here for his Hollywood connections/experience, and his experience with toys, as merchandising will get a big push alongside the film, no doubt. The movie is a big commercial for Nintendo's games, and to get the IP further exposure to a wider audience, as was always the plan ever since the failed Netflix deal.
Edit: I was wrong. Avi Arad did not produce/exe Spectacular Spider-Man. That was Victor Cook (season 1) and Diane A. Crea. Sony Pictures TV, but no Arad involvement from what I can tell. Still my favorite piece of Spider-Man media.