I hope flying low over pretty places doesn't become popular. Planes are really noisy.
I had to live with that for two years. All very annoying.
I say this as a person that lives within a couple of miles of a big airport. So not guessing.
https://envhealthcenters.usc.edu/2019/02/ultrafine-particle-...
Large airport flight paths can have different sounds though.
Overall, the turboprops that the airlines used didn't ever bother me at all.
But, on parents weekend and at graduation, the airport had a lot of private jets flying in, and the noise difference between the prop planes and the jets was disruptive.
It's not a big deal, except for the big military transports; those things are loud and don't care.