With manual wipers, you always need to manually turn on the wipers.
I don't get how the auto wipers are worse. It's not like having auto wipers means you no longer have manual wipers. Other than maybe a Tesla where they took away the stalks, but just about every car I've had with auto wipers still had regular stalks with pretty regular wiper controls. Just one speed is also auto, so you can leave it there instead of off.
And in the end I'll leave it on auto instead of off, and the majority of the time these days I don't even have to think about it. These days, they seem to mostly just work for most of the precipitation I experience. Not always, but most of the time.
The first car I had with auto wipers was kind of like your experience. It had to really be coming down to activate. That was a 2012 model year. My 2017 model year car is a good bit better in that kind of misty environment. My 2021 car, I pretty much never touch the wipers even if it's just a light mist. The tech has seemingly been a lot better over the years.