The Stoica and Moses book gives a thorough derivation of this, so I’m not going to repeat it here. For filtered white noise, the output periodogram is
\begin{equation} \hat{\phi}_{y}(\omega) =|H(\omega)|^{2} \hat{\phi}_{e}(\omega) + \mathcal{O}(\frac{1}{\sqrt{N}}) \end{equation}
where $\hat{\phi}_{e}(\omega)$ is the noise PSD, and $\mathcal{O}\frac{1}{\sqrt{N}}$ is an unkown constant $\in \: [-\frac{1}{\sqrt{N}},\frac{1}{\sqrt{N}}]$ depending on the draw of the white noise, or something like that.
What this means is that, for filtered white noise, which can describe a large variety of signals, the variance of the periodogram approaches the variance of the white noise plus a constant proportional to $\frac{1}{\sqrt{N}}$ (with scaling of $\frac{1}{\sqrt{N}}$ for the FFT). If using $\frac{1}{N}$ in the FFT computation, you get an $N^{2}$ in the periodogram denominator, which will produced a biased estimate of the periodogram. Haven’t worked out the math in a while, but if I remember correctly it will get rid of the constant term due to the noise input asymptotically, making it consistent, but this results in a scale factor bias.
It’s important to note that Bartlett’s, Welch’s, etc, while consistent, are biased, not asymptotically unbiased, like the periodogram. To achieve this, you need MVM or a modern parametric technique.
EDIT #1 Discussion of statistical properties of the periodogram and its derivatives
There's a couple ways to dissect this. Often times the periodogram is thought of as unbiased, but it's not, it's asymptotically unbiased, and this is actually a very important point. For white noise, the periodogram is virtually unbiased, except for cases with very small $N$. However, for most other cases, the periodogram is biased, even for large $N$, especially for signals with high dynamic range, because of the sidelobes of the Fejér kernel. This is easily verified by generating an AR PSD as they have a closed form solution, and the exact PSD can be known from the AR parameters. A picture is shown below.
As you can see, the periodogram follows the true PSD with relatively zero bias until the high frequency content where it starts to deviate from the true PSD. To be fair, other PSD methods including mismatched parametric models also suffer this bias. In line spectral cases I believe Eigenvector produces an unbiased result. Regardless, it is important to note that in cases of high dynamic range, many PSD methods, particularly most filterbank methods, will suffer bias.
Notice also that Welch's method suffers a severe amount of bias (a decent amount of averaging was applied to emphasize). At the peaks, Welch's method underestimates the true PSD value, whereas elsewhere, Welch's method overestimates the true PSD value. This is because bias = resolution for spectral estimators. The less resolution you have (compared to full resolution), the more bias you will have 1. Because by definition Welch's method (or any periodogram derivative method) cannot be full resolution, it will always have inherent bias. This is also not just the case for line spectra in noise (even though the above picture was of an AR process, ie filtered white noise, which covers a wide variety of cases, other interesting things happen when using other examples). Take for example a linear FM chirp. Below is a picture of this case.
Because of the bias, Welch's slightly underestimates the bandwidth of the chirp, although it has better first sidelobe response. Playing around with the values of the window, segment size, and overlap size can get you a combination of 3 dB mainlobe width and PSL that gives the appearance of being unbiased and consistent, but this is trial and error and may not always work, and mathematically isn't consistent since resolution = bias.
With respect to my point in the comments about the error, the easiest way (IMO) to quantify the error, and the method used in 1 for a lot of their discussions, is MSE. The MSE of a PSD is $\sigma^{2} + (\text{bias})^{2}$. When empirically comparing single draws of different PSDs, this is a pretty hard thing to quantify, especially for a wide variety of different cases. For example, you could potentially make the argument that for the AR process the periodogram has less MSE, whereas in the LFM case Welch's may have less MSE. It's really hard to say, but my point was primarily to say that if you changed error to variance you would be correct across the board.
At the end of the day, without getting into far more complicated techniques, the only way I can think of to guarantee an unbiased and consistent PSD estimator is to have a matched parametric model. Hopefully this discussion clears up some things on what I was trying to get at!
EDIT 2 Practical Implications
The pictures shown in this post don't necessarily reflect a likely selection of parameters for Welch's method. As such, they are meant to be extreme cases to demonstrate the bias that Welch's introduces. In practical scenarios with more reasonable parameter selection, it is unlikely that this amount of bias will be seen, although some bias will be present.
1 Stoica, Petre, and Randolph L. Moses. Spectral analysis of signals. Vol. 452. Upper Saddle River, NJ: Pearson Prentice Hall, 2005.