Literally this very website you're posting on has an entire database.
https://na.finalfantasyxiv.com/lodestone/playguide/db/

Like it's the official website even. While it may not be as feature rich as some other sites (garlondtools), or as easy to access due to LACK of features as some others (gamerscape), it's always kept up to date with the patches since SE updates it along with the game. You're not relying on a third party to ensure proper data.

All three options listed have exactly what you complain you couldn't find. Where things are procured, where the NPCs related to them are, what quests may be involved, how much it sells for, etc.
Also complaining about ads? Adblock is your friend. Though that's another plus to the Lodestone I guess. SE doesn't need to sell ad space since you already pay for it lol.

Edit: Dangit, Kleeya beat me to this.