Which webcam is best for low-light home offices?

Across r/logitech threads, the Logitech MX Brio is repeatedly singled out as 'much better' in early-morning, low-natural-light conditions than the older Brio 4K. The Insta360 Link 2 / 2C also gets praise from TechRadar and Fstoppers for HDR and low-light handling thanks to its 1/2" sensor. Budget webcams like the Brio 101 are consistently called grainy in dim rooms.