Produce Wealth might be something worthwhile to do in a city with the Temple of Forgetting, if there isn't anything else worth building there. I might also make use of it and the Guild Warehouse if I come across a location which is spectacularly good at money production (meaning multiple gold mines and a reasonable amount of essence for Propaganda, especially with high materials (including bonus from Arcane Forge) if I expect the game to last long enough to worry about a Mint of Ruvenna), but I rarely bother making such a city. I tend to find gold isn't valuable enough to delay settlement development for, and most of my settlements never stop building things before I finish the game.
Same goes for the Archivist and Produce Research - I don't see that the extra research is enough to be worth delaying the development of a Conclave for, and research structures are usually not a very high priority in my non-Conclave settlements so there isn't much incentive to boost research from those locations unless I simply have nothing better to do with them. I'd sooner take Scroll Scribes and Oracles over Archivists because at least those offer bonuses that don't require me to postpone the development of the Conclave.
I tend to feel that one issue that Archivists and Guild Warehouses have is that they come too early in the development of a settlement - unless a settlement grew very slowly or unless you've been very slow on improving food production, a level 3 city has too much more infrastructure that I'd like to have which still needs to be built for me to really want to switch over to 'produce research' or 'produce wealth' in almost every case that I can think of. It doesn't help that the Guild Grocer provides a benefit far more generally useful than the extra gold that a Guild Warehouse can theoretically provide, or that the benefits from Oracles are more flexible and that Scroll Scribes provide excellent consumables for champions, and that Scroll Scribes, Oracles, and Guild Grocers work no matter what the Conclave or Town is building whereas the Archivist and Guild Warehouse only work while using the appropriate 'Produce X' options.
Produce Growth is something I might use if I wanted to get a city to the next level quickly, or if I needed just a little bit more growth next turn to get a Pioneer. Otherwise I won't usually bother, since there's no real value to having a larger population except for when it gives you a new city level. I might occasionally go in for making a high-growth town just to play around with the various sacrifice spells, but that's about the only other thing I can think of that growth would be useful for.