If I need to monitor thousands of wallets, how can I do it?

I want to be able to notify a user immediately of a payment

looks like bitcoin core can tell the balance only of local wallet. Kinda strange