It depends upon the users needs clearly some people are happy others not.
Also it’s not just the photosites beinf small but the aperture is also small comparativley.
There are some decent night pictures, not exactly astro 
https://forum.fairphone.com/t/fp4-pictures-gallery/78667/2