Le Cafe and Satsanga are the best cafe. Satsanga serves french cuisine alongwith Indian including French wine. Le cafe serves Indian plus continental. If you have kids, you need to book the family section in advance (it was so way back in 2017). Both are in the French colony/white town area.
Besides you should not miss the cafe inside Auroville, Bread and Chocolates. They serve mouth watering cupcakes alongwith other food