Experiencing android notifications not showing until you manually open an app is an extremely common frustration. The underlying reason for Android notifications not showing up is aggressive OEM battery management (Samsung One UI, Xiaomi MIUI, and OnePlus OxygenOS) putting background messaging sockets into deep hibernation.
Go to Settings → Apps → [Target App e.g. WhatsApp, Gmail] → Battery. Switch setting from Optimized to Unrestricted. This exempts the app from Android Doze background network cutoff.
Under Settings → Apps → [Target App] → Mobile data, verify that Allow background data usage and Allow data usage while Data saver is on are both toggled ON.
On Samsung devices, open Settings → Battery and device care → Battery → Background usage limits. Check the lists for Sleeping apps and Deep sleeping apps. Remove any messaging, email, or security camera apps found there.