Yes, Vivo Y93 does have the portrait mode in both sides of cameras.
Yes, Vivo Y93 does have the HDR support in both cameras - front and rear.
No. Vivo Y93 is not a water-resistant mobile phone.
No. Vivo Y93 does not have the LED notification light but it does have the always-on display.