A Bowden tube extruder (like the stock one on an Ender 3) is known to have issues with printing the most flexible TPU, and with filaments that (either due to composition or condition) don't take well to too much retraction -- though the latter can be ameliorated somewhat with slicer settings. Direct drive extruders, on the other hand, by reducing the extruder to hot end distance to the practical minimum, greatly reduce the amount of retraction needed as well as the effect of filament compression and stretching.
One potential down side I'm aware of is that putting the extruder stepper and drive on the X carriage adds mass that the X drive motor has to both accelerate and decelerate; this could in theory have an effect on print quality, increasing ringing and overrun on the X axis (though this isn't generally a problem with the steppers used on the Ender 3 and similar printers).
What other reasons might there be to prefer a Bowden tube over direct drive?