Not the parent, but my situation is similar to yours and so I'll offer my experience :

First, raked out [thinned / dethatched bermudagrass rhizomes] an area roughly 100 square feet. Broadcast region-appropriate wildflower and herb seed mixes [I'm in the southwest, but regional mixes are available everywhere].

Planted lots and lots of herbs in containers - mints, basils, and every kind of kitchen herb. Herbs tend to attract masses of bees with their yummy inflorescences. Had the added benefit of creating a supply of fresh kitchen herbs. I started out with probably two dozen herbs in containers the first year.

Planted lots of sunflowers in borders and pre-existing beds. Bulletproof plants that attract an alarming number of bees. Also had the side benefit of attracting a flock of feral lovebirds [!], who ate not only the seeds but the flesh of the plant [!!]

Planted a goodly number of squash and pumpkins all around, wherever space permitted

^ that was the first year, and boy I tell you, did the bees ever come! I was amazed to see mobs of bees on the sunflowers and gangs of bees fighting to occupy the pumpkin blossoms. They teemed on the spikes of mint flowers and buzzed in the chicory. All this with very little effort -- the above plants require very little maintenance beyond judicious watering. The one 'trick' is to water with a fine spray wand while the seeds are getting established, so as not to dislodge them.

The second year, I planted sweet clover [Melliotus altissumus] and flowering fruit trees [peach, citrus, apple] and spread more wildflower seeds around. The sweet clover grows tall but pays off with just ridiculous amounts of bee action and great aroma.

The original wildflower planting had already 'established' and a lot of the annuals in there self-seeded. Same goes for herbs like basil. I planted even more herbs in pots the second year, going for more variety, and carrots which if allowed to flower are massive pollinator attractors.

The bees came in droves -- all kinds of bees, not only honey bees -- I mean big black carpenter bees, little shiny orchard mason bees, black-and-white-striped bees, bees that live in the ground, all kinds. Plus a great many other insect and bird pollinators. Plus more dragonflies!

And it just kept building like that, with the plants doing most of the work themselves. Now the place is like 'The Secret Garden" or something, always abuzz with bees and I'm quite sure that it's the nexus of bee activity in the neighborhood. In fact, it worked a little too well, with one colony of bees establishing itself inside my laundry room wall, haha! [but that was an anomaly]

We don't have an HOA, but an annoying neighbor did complain about the wildflowers one year, citing a dumb city ordnance prohibiting grass over six inches in height. The city came to inspect and basically said "uh yeah, we're not gonna issue a citation against a wildflower garden."

Lot size in my case is a quarter-acre, but I think based on observed results that a real impact can be made with almost any lot size. For reference, I broadcast about two pounds of seeds in total the first year, and usually "re-up" with a pound or so annually, depending on how things are looking. Overall, one of the most satisfying endeavors I've undertaken.