There is generally no hard limit to the number of photons per unit area in the sense that photons can overlap without issue (i.e., don't think of them as hard billiard balls). This ultimately comes about because photons are bosons, so the Pauli exclusion principle does not place restrictions on them like it does for fermions.
However, there can be many practical limits to the number of photons per unit area. These will depend on the frequency of the photons, as it may be easier to have lots of low-frequency RF photons compared to lots of gamma ray photons. One such limit is the Schwinger limit, where photons start to interact with each other and thinking of them as independent particles does not work anymore. This limit arises when the total electric field of the photons is large enough to create electron-positron pairs out of the vacuum.
If you have enough photons to reach the Schwinger limit, then you reach a non-linear regime, where some of those photons will (nearly) instantly disappear and turn into electron-positron pairs (and eventually back to photons), and the remaining photons will not behave at all like the light you are familiar with, so they should really be called something else - perhaps a "photon liquid"? Maxwell's equations don't apply here as in linear optics, so the physics is truly different.
The Schwinger limit is when the electric field reaches
$$E_s = \frac{(m_e c^2)^2}{e \hbar c}$$
The electric field from a source with $N$ photons per second with energy $\hbar \omega$ per photon over an area $A$ is given by
$$E=\sqrt{\frac{2 N \hbar \omega}{c \epsilon_0 A}}$$
Equating the two and solving for $N/A$ gives
$$N/A=\mathrm{Photons/Area}=\frac{1}{\hbar \omega} (\frac{(m_e c^2)^2}{e \hbar c})^2$$
$$\mathrm{Photons/cm^2}_{\mathrm{Schwinger}} = \lambda [nm] \times 2.33\cdot10^{45} \frac{\mathrm{Photons}}{\mathrm{Second\cdot cm^2}}$$
where $\lambda$ is the photon wavelength in nanometers.
This limit is extraordinarily high, and has not been achieved on earth with any man-made light source yet.
Another practical limit is the number of photons needed to destroy any material via ionization. Here you could perhaps use the Rydberg constant ($13.6$ Volts) and Bohr radius ($\sim 50$ picometers) to construct an estimate for an electric field that would rip apart electrons from any atom. This estimate gives
$$\mathrm{Photons/cm^2}_{\mathrm{ionization}} = \lambda [nm] \times 10^{32} \frac{\mathrm{Photons}}{\mathrm{Second\cdot cm^2}}$$