Unfortunately managing a HOA lake where all the residents aren't on the same page is like saying I want a car to get 60 mpg, hold 6 people comfortably, be able to tow my 25 foot boat and be able to run low 5 second times at 270 mph in the quarter mile.

What you are trying to do, and have everyone be happy, with the budget that you have to work with, just isn't realistic. It can't be done.