I don’t think the “Caesar’s Wife” concept would work well today.
You’re right. Such a thing could only work in a high-order, high-trust society, something which nowadays we only have vestiges of. But in theory the ‘Caesar’s wife’ concept seems like a good m.o., even if just reserved for the highest levels.