Let $ξ$ be a singular Gaussian noise on $\mathbb R^d$ that is either white, fractional, or with the Riesz covariance kernel; in particular, there exists a scaling parameter $ω>0$ such that $c^{ω/2}ξ(c\cdot)$ is equal in distribution to $ξ$ for all $c>0$. Let $(ξ_\varepsilon)_{\varepsilon>0}$ be a sequence of smooth mollifications such that $ξ_\varepsilon\toξ$ as $\varepsilon\to0$. We study the asymptotics of the moments of the parabolic Anderson model (PAM) with noise $ξ_\varepsilon$ as $\varepsilon\to0$, both for large (i.e., $t\to\infty$) and fixed times $t$. This approach makes it possible to study the moments of the PAM with regular and singular noises in a unified fashion, as well as interpolate between the two settings. As corollaries of our main results, we obtain the following: $\textbf{(1)}$ When $ξ$ is subcritical (i.e., $0<ω<2$), our results extend the known large-time moment and tail asymptotics for the Stratonovich PAM with noise $ξ$. Our method of proof clarifies the role of the maximizers of the variational problems (known as Hartree ground states) that appear in these moment asymptotics in describing the geometry of intermittency. We take this opportunity to prove the existence and study the properties of the Hartree ground state with a fractional kernel, which we believe is of independent interest. $\textbf{(2)}$ When $ξ$ is critical or supercritical (i.e., $ω=2$ or $ω>2$), our results provide a new interpretation of the moment blowup phenomenon observed in the Stratonovich PAM with noise $ξ$. That is, we uncover that the latter is related to an intermittency effect that occurs in the PAM with noise $ξ_\varepsilon$ as $\varepsilon\to0$ for $\textit{fixed finite times}$ $t>0$.