I’ve got a Fedora 36 machine with a couple of Maxwell Quadros. When I sleep the machine, it sleeps successfully, but when I try to wake it up, the display doesn’t light up, but Fedora itself manages to come back because I can SSH in, it’s just that there’s no video. I’ve checked dmesg, but there’s no errors from anything Nvidia related. I’m running 5.19.3 with the Nvidia driver being 515.76 from RPMFusion.
There are some reports of a similar bug on Ubuntu - maybe one of the work arounds would work for you? I’d search for a similar bug on the redhat bugzilla (which IIRC is used as the Fedora bug tracker).