I was too building something similar 2 months back.. the intent was to be able to locate places with such queries, for example:
"sparsely populated urban residential areas with >75% greenery nearby".
I was able to make it work.. tested it on a small area of 50x50 km2.
But the costs were insane.. first to populate the database, and then to host the query engine.
HippoMaps runs on a 4-core AMD from 2019 with 64 GB ram and 1 TB ssd. The map tiles are on a separate server that's more beefy but I also sell access to Overpass there so that covers the costs more or less.