How to amplify 0-10V 100Hz-1µHz sine wave to drive 24V 5A LED module?
Classical op-amps work just fine down to DC. However the input noise does increase at low frequencies. At sufficiently low frequency, we stop calling it 'noise' and start calling it 'drift'.

If you want an amplifier with the lowest possible noise down to DC, then use a chopper-stabilised op-amp. This employs an auto-calibration loop round two amplifiers internally, to null out the drift as it happens. 

However, it's quite unusual to have an application that is so sensitive to drift that you need to go to the expense of this type of amplifier. A good compromise between the el-cheapo amplifier and the chopper stabilised is a 'low drift' amplifier with a specified input drift and input offset voltage tempco.