I already have this for consumption up to 0.1 Watts:
https://de.elv.com/elv-energy-master-basic-2-energiekosten-messgeraet-130412For me, the question was how to detect and measure lower power draw, and I have several multimeters and adapters on my bench ;-)
I was thinking of the following setup:
Isolation transformer to float the DUT. On the L' I would place a handheld multimeter for Amps measurement. After the multimeter, I would place the socket for mounting the DUT, and where the N' from the isolation transformer is connected.
Measuring of current by the DMM itself, and then I thought of connecting the mass from the scope to the COM port of the DMM as a common denominator.
(And therefore earthing the whole stuff again, unless a differential probe would be used- this for reference for later readers that look for suggestions, as this will blow up when accidently wiring this in the wrong way)
The scope would measure the voltage drop above the shunt of the DMM, and the voltage after the DMM and N', therefore being able to have some idea of the difference between voltage and current.
Depending how well I would get the measured data out of my scope, I can piece them together later in some external application with ease.
The role of the DMM here is to provide a good quality shunt including protection mechanisms around it, and to give me an idea of the current currently flowing, so to get some rough idea to check if the values the scope measures in relation to the measured resistance of that shunt+DMM fuse are plausible.
Of course I will have to use some 100:1 probe for the 230V portion of that setup to get that signal conditioned...