Non-Asymptotic Pointwise and Worst-Case Bounds for Classical Spectrum Estimators