My family are all based in Pondicherry and have very strong historical links with the Sri Aurobindo Ashram and the Mother. And are also involved in the Auroville administration and management. I've been there a lot, I've stayed there, met many people who live there and work there.
And it's an unusual place. Some of the folks in Pondy call it "Horrorvile" because of the reputation of seediness that some residents are alleged to have (sex abuse of local children, if you want to know). There is also a unusual "un-Indian" feeling about the place because of the nationality of its residents (global).
However, I have met only nice people there, doing wonderful projects (solar bike sheds, environmentally-suitable architecture) and it is well worth a few visits.
On the other hand, there is quite a difference between the mission statement and the practice of its values. Money isn't really supposed to change hands for work and housing. This is bullshit; many people have commercial sidelines and housing does get bought and sold. Rules are there to be bent and of course, they are.
Some of the security staff can be real jobsworths and exceedingly officious, which can irritate people. And it feels a bit lawless in some regards, hovering uneasily between spirituality, cultishness and the Indian democracy.
It's a peculiar place. But you probably got that already.