Has "municipality builds kinda neat thing to revitalize local economy" ever worked?
Take a look at Niagara Falls, for example - those viewing platforms and paths and boat launches aren't natural features. Making it easy to get access to spectacular views seems like a pretty good investment in general.
If you are coming from far, you'll likely prefer to spend your time in Porto and Aveiro.
I guess they'll have more local visitors. If I were in Alquerubim I'd definitely go there on the weekend.