I mean, it's not that you can't create a new and compelling dynamic with Hardy and Holland. It's just a question of if Marvel will do it. Do they even want that rivalry?
If they do, I can see a scenario where Brock and Peter start out as allies. Brock gets injured and Venom needs a new host. So he latches onto Spider-Man. Venom then learns about Uncle Ben and we get a sub-plot where he pushes Peter to murder Ben's killer. Of course Peter ultimately refuses and rejects Venom. Venom, hurt and humiliated, then returns to a recovering Brock. Only now he has Spider-Man's true identity and the added knowledge that Peter, early in his superhero career, was secretly tied to whatever caused Eddie to leave New York for San Fran.
I'm not trying to say this idea is all that compelling, but it hits on a lot of the familiar beats in a new way. A better writer than me could map it all out in a clever way.
Still, assuming Sony can get Garfield back, I think TASMverse is a better tonal match for this Venom. I would have Brock in that world and Gargan as the Venom in the MCU when all is said and done.