I would consider a 6 grain tile great for 2nd or 3rd city, after that not so much. As mentioned by earlier posters, you can deal with lower amounts of grain as the game goes on. However for the early game,being able to get a quick Oracle, Infirmary or Scroll Scribe up early can be a godsend. (lvl 3 cities) They give 1 more Essence , more HP for troops, and Blizzard Scrolls (imba stuff when playing high level AI's) respectively.
Also: Of the three city types, which would be best suited for a 6 grain tile (with a grove tile adjacent and 3 materials)? I would say a town, but this is my third city and my first two are both towns. If it effects my choice, I should mention that I'm playing as the Kraxis. Thanks in advance
All except a town. My towns are high production ones since they have great food and growth buildings exclusively. Need Research? Conclave, Need good troops? Fortress. Towns are for junk sites and gildar mostly until later when you want +Faction Food for all your cities. Don't need high food for any of that.