It seems that there are examples. By a theorem of Gromov and Lawson every simply connected manifold of dimension $n \geq 5$ which is not spin admits a metric of positive scalar curvature. There are many examples of simply connected, non-spin, closed $6$-manifolds which cannot admit a smooth circle action, constructed by Puppe. Theorem 7 of https://arxiv.org/pdf/math/0606714.pdf. Then, since the isomotetry group of a closed manifold is a compact Lie group, if $N(M)>0$ then taking a maximal torus gives a non-trivial circle action, which contradicts the above. So every metric has isometry group of dimension $0$.