Thanks. It really helps to learn these details… but, you know, your question gave me a pause — do they? … wait a minute…. ???
Seriously, as far as I know aphids don’t lay eggs. They bear live young. The adults may overwinter under bark or in sheltered pile of dead weeds, etc. They can fly in from elsewhere then lose their wings … but … another way they overwinter is the ants shepherd them and keep them in their nests, then bring them out and pasture them on likely plants.
You can get a lot done just controlling ants.
I keep a chem-free garden and try to practice as “organic” gardening as I can. You may get other opinions and recommendations from others … but here goes
From my perspective, aphids are one of the lowest totem pole in the wild foodweb and are not considered to require much concern or attention except indoors during winter and very early spring before the beneficial predators have had the chance to re-establish and keep them in check.
Early spring — blast them off of plants with strong sprays of water, put out ant traps and baits, watch for arrival of beneficials, where possible, cut off mass infested parts of plant and destroy … as last resort, spray with soapy water to suffocate and kill, then rinse off…. I *might* use neem oil spray or other natural deterrent (diluted coffee, very diluted vinegar, etc.)
Back off as soon as Aphid Mummy Makers and Hoverflies arrive, then keep an eye out for arrival of ladybugs, spider hatching events, praying mantis hatching events, and green lacewings eggs, and distribute them to other aphid infested plants as needed….
Your op statement that you’ve spent hundreds (presumably on pesticides) — that may have disrupted the population of beneficials, and only because you’ve let the aphids proliferate, they have recovered to begin repopulating.
It’s important to identify other reasons your crop might be failing. You implied that they grow well but you don’t get to enjoy harvesting.
Zucchini and Spaghetti Squash are susceptible to Squash Vine Borers — they typically produce one or two to few fruits then wilt/collapse.
Melons and watermelons are often victims of wilt disease carried by leaf hoppers and other sucking pests and/or cucumber beetles and yes squashbugs and other stinkbugs. But in my garden, it’s the larger spotted cucumber beetles (that arrive later than the smaller striped cucumber beetles, just before the stinkbugs) that are the most likely perps.
etc.
One other possibility that drew my eyes— just beyond your trellis, there is a huge expanse of what looks like grass, grass, grass — no broadleaf weeds.
Is that part of your property? How is the herbicide etc. being applied and what kind? Could your garden have been affected?