When we installed our MV cameras (summer 2019), we knew there was a delay. We were experiencing 8-10 seconds. Starting around October, we now see 3-5 second delay. I don't know if something changed in the firmware or in our network infrastructure, but it got better in October. We can live with 3-5 seconds, and my understanding is that with cloud/web technology, it will never be 0 second delay. Maybe they can bring it down to 1-3 seconds.
I can see needs where 0 delay is needed. For us, 3-5 is OK.