Unless you are making money off tourists, which many locals aren't, then generally it is a pain. Not everybody has a cafe/shop/burger stall. Nurses, teachers, farmers etc live in tourist areas too. The increased people and traffic is generally a pain, to be frank.
Tourist money doesn't just benefit the owners of souvenir shops and cafes etc., though. One, two or more steps removed, the money still trickles through. The farmers you mention: don't they supply any of the food establishments that depend on tourist trade? What if you're a car mechanic whose exclusive customer base is locals.... BUT some of them can maybe only afford to buy your services because of their earnings from their holiday cottage?
I've said it before on similar threads, but I live in a very untouristy part of the West Midlands region; however, we have a lot of motorways around us, with multiple service stations, which employ a lot of people, whose (taxed) earnings help to boost the local economy. Who do you think is stopping off to use all of those services and spending money there? Not people who live within 40 miles of them - it's almost exclusively people passing through on long journeys, many of whom will be tourists.
I hate shameful tourist behaviour as much as any half-decent person, but when it comes to the well-behaved tourists, surely it's a case of either accepting that you live somewhere beautiful (and enjoying living there permanently yourself) or moving somewhere horrible/boring, where neither you nor any tourists will enjoy the surroundings.
Just as I benefit greatly from our Midlands motorway network, which I accept also draws a lot of motorists wanting to travel quickly and efficiently through the country, but which therefore can get greatly congested and jammed during peak holiday/commuting times. People living permanently in beautiful places like Cornwall, Norfolk, most of Wales and the Highlands neither have to put up with motorway through-traffic nor benefit themselves from speedy travel on motorways either. A lot of things are a trade-off, wherever you live.