I am of the opinion that the current quest system is both too strong and exploitative feeling but also breaks one of the things I value most which is the sense of immersion - I have always loved about the game that POIs and routes through POIs are more or less whatever you want - I went back to play Fallout for example and not being able to just chop out a door was so silly feeling. But I think that the mechanism of a quest "resetting a POI" creates an easy loop to loot a house (or nerd pile up to the end loot if you know where it is) trigger the quest and reset the POI and do it again; you can endlessly 'farm' POIs for mats, instead of creating a natural pressure to expand and explore new areas to scavenge.
I think opening trade routes is a good idea; I think you could possibly keep Buried Supplies (esp now with the changes) as long as it was a limited number to prevent holes-regrowing if you selected the same spot twice; and I think you scrap fetch, clear, and power. (Its cool to see a new one but it really doesn't add much, imo) : in their place, you put maybe something like supply requests at traders : lower tiers ask for smaller quantities or more common materials; higher tiers ask for harder to find ones. You could add POI-specific items to scrap or loot (sink parts, valves, whatever) to encourage exploration of new POIs; you could add "zombie eyes" as a lootable for killing quests; you could add some zombie part that only drops from some zombies (cop hats? biker vests?) or at night only? to encourage other kinds of dynamics. I think keeping the "tier completion" level is good too but could be tuned.
I know I can just not do them, or not do them in the exploit-y way, but I was just hoping for something a little more "in game" feeling. If there's an existing mod that does some or any of that I'd love to hear of it.