Of the ones I've actually been to -
Marseille (Euro 2016) is the best stadium I've been to full stop but to watch Notts it would be -
Best - Sheffield United (I've been to bigger and newer but atmosphere was brilliant).
Worst - Hereford (of the current 92 it would be Colchester or Shrewsbury because of their location.