I’m very intrigued by artificer, and I think you’re absolutely right: it has utility reminiscent of bard, but gets a prepared list that swaps like a cleric/druid (no having to worry about getting access to the spell), and a bunch of other utility through infusions. Filling your hideout with sentient plant spies through replicating Pots of Awakening is exactly the kind of stuff I’m looking for. The spell list is a little shallow to me, definitely not the same depth as the wizard list especially since it cuts off at 5th, but there are a decent number of niche tools there.
If there ends up being a good niche for a Defender or Scout, Armorer is on my shortlist, especially because it can plausibly fill both roles with the same build.
Yeah that’s valid, the case where we’ve suddenly lost an item or are trying to take it might come up very suddenly. I was thinking more of a situation where you know the maguffin is in an area but don’t know where, or are in the right house but need to find its hiding place: you often go into that with advance knowledge.
I chose Locate Object as my example spell because it’s on a lot of spell lists so is plausibly something that could be used no matter what class other people suggested, which actually kind of cuts into the concept of wizard supremacy. Arcane Gate, Modify Memory, Seeming, Guards and Wars, Fabricate*, Control Water, and Speak with Dead are all also good candidates for “I don’t know how often this would come up, but when it does boy howdy is it useful”
*Fabricate might be good enough to be learned by a spontaneous caster.