Does Big Bang red shift affect the frequency of both light waves and individual photons?
Yes it affects both. If you treat light as waves then the wavelength from a source at a redshift $z$  is "stretched" by a factor of $1+z$.

Photons emitted from a source at redshift $z$ have their energies reduced by a factor of $1+z$.