Fedora 38 Failing To Boot With NVIDIA Drivers After Software Update

The problem seems to be the nvidia driver.

The nvidia 470xx driver was available long before the RTX 3060 GPU was in use, and does not support wayland at all. The 470 driver may not support the 3060 at all.

I would suggest removing all nvidia 470 driver modules and installing the latest driver in its place so the GPU is properly supported and wayland is also supported.

sudo dnf remove \*nvidia\*470xx\* --noautoremove should handle removing all the older drivers.
sudo dnf install akmod-nvidia xorg-x11-drv-nvidia-cuda should then install the current nvidia drivers which are the 545.29.06 version