Bonjour, we worked with ADC and DACs since 1968, for signal analysis and audio, FFT.
The post seems to have mixed SNR, ENOB, (effective number of bits) noise and oversampling (OS) ADC theory.
RE issues of zero input, several LSB bits are active, see classic noise theory, all ADC have noise floor, OS or not.
Many fine sites, papers and references on SNR and ENOB in ADC.
The advent of powerful real time DSP made practical the oversampling ADC, first by Nippon TT
https://patents.google.com/patent/EP0190694A2/enMotorola ADC IC 1985 app note:
http://xanthippi.ceid.upatras.gr/people/psarakis/courses/DSP_APL/demos/APR8-sigma-delta.pdfSoon all the analog/ADC firms were deploying OS ADC and wrote app notes: 1980s,,1990s See Analog Devices, Cirrus Logic, TI, AKM, etc.
Oversampling is based on information theory and practical FIR filters.
By sampling much faster then the Nyquist theory would have, eg 100X or 1000X and permits a fast but low res ADC, one has effective captured the information at resolution info but spread the spectrum 100X or 1000X wider.
The result needs a real time digital filter, often and FIR 30-100 stages.
The filtered result is a high resolution digital signal of the original analog input. It is possible to OS so fast the OS bitstream is one bit!
Again, many sites, papers and app notes, here is a TI paper for RF and IF, still good background,
https://www.ti.com/lit/an/slaa594a/slaa594a.pdf?ts=1643469546792With many great OS ADC and DAC easily available, no need to DIY the converter!
Hope this note clarifies the situation,
Kind Regards,
Jon