I just ordered an i-extruder solder paste dispenser (https://www.i-extruder.com).
Based on the videos, it seems suitable for 0402 size pads. I think I can tweak it for 0201 and BGA. I will make a review video of the device and my attempts to tweak it.
Even if I can’t succeed, it will still be useful for my larger boards that use 0402. It seems like a much more convenient tool than pneumatic desktop systems, especially given that I don’t make prototype PCBs all that frequently (maybe once a month).