Versus night sight? The single shot with wide enough glass is definitely going to be better: there just aren’t many photons on the little sensor! But the stacking that night sight does “in camera”, particularly since the Pixel 4, seems to outpace “cheap DSLR”. Here’s a basic Nikon vs Pixel 2 a couple years ago [1].

[1] https://old.reddit.com/r/GooglePixel/comments/9rb53o/weekly_...