hippy is disqualified from an answering.
Have any of you found an application for its use?
I'll pretend I'm someone else as you're not getting any answers on the potential use / have used side.
The comparators are simply that, giving a digital output which indicates if one signal is greater than another, so it can be used as a simple version of two READADC commands and a comparison of results. Thus -
ReadAdc 1, b1
ReadAdc 2, b2
If b1 > b2 Then Goto FloodingAlert
could be replaced by -
If comparatorOutputBit = 1 Then Goto FloodingAlert
That will be quicker to execute which may be important. It also uses less variables and less code space. Though the later is offset by having to set the comparators up.
On the PICmicro there are also other options available which give a wider range of potential uses. COMPSETUP allows many options to be set, poking SFR can get at some other options.
One PICAXE example use for these was to use the comparators to take a 0V/3V3 input level signal, compare that against say 2V and use the output ( which will be 0V/5V) to drive a PICAXE input which expects 0V/5V. This gave an on-chip voltage level converter.
What it really gives is an advantage to the designer of a circuit. If they need one or two comparators in their circuit they can instead use the ones on-chip. That saves an additional external component, cuts costs. Later PICmicro/PICAXE have selectable UART TX and RX polarity. By adding that it saves having to invert polarity externally. It comes down to the more the chip can do itself, the less you need to add to make your circuit work, which makes that product look appealing against other options - "One chip to rule them all".