i can provide 2 of my personal samples (nokia 7 plus)
https://i.imgur.com/k0InrHM.jpg
Auto mode
1/20s ISO-245
(the most evident noise are the white specks in the night sky)
If you shoot auto, the shutter will never go slower than 1/14 (can be tested by covering the lens completely) but i personally feel that for night scenes you need 1/10 or less, else will still get noticeable noise... (alternatively, use stock app with HDR at night and it can help a bit at producing less noisy images but imo these HDR things tend to reduce your image detail too)
https://i.imgur.com/Torn93E.jpg
manual mode
1/5s ISO100
(if the phone had OIS i probably could do 1/4s handheld, but this is my max limit for a phone without stabilisation)
yes it has no OIS but usually where that suffers more is if you try to shoot 4K video. the 1.4 micron pixels at least helps light capture so if you go manual handheld for low light you may not need to exceed ISO 200 so it wont need to end up like a sony where the ISO is so high leading to even more noise
i feel that the image processor doesnt like dark objects that much. its not even about dim scenes, any well lit object, as long as it is dark gray or black, will have more RGB noise that the rest of the scene