By means of rigorous numerical simulation calculations based on the Green's theorem integral equation formulation, we study the near EM field in the vicinity of very rough, one-dimensional self-affine fractal surfaces of Ag, Au, and Cu (for both vacuum and water propagating media) illuminated by a p polarized field. Strongly localized enhanced optical excitations (hot spots) are found, with electric field intensity enhancements of close to 4 orders of magnitude the incident one, and widths below a tenth of the incoming wavelength. These effects are produced by roughness-induced surface-plasmon polariton excitation. We study the characteristics of these optical excitations as well as other properties of the surface electromagnetic field, such as its statistics (probability density function, average and fluctuations), and their dependence on the excitation spectrum (in the visible and near infrared). Our study is relevant to the use of such self-affine fractals as surface-enhanced Raman scattering substrates, where large local and average field enhancements are desired.