I can only show it with cherrytree as I was able to install tweaks after many tries/updates, etc. Still couldn’t figure what fixed the installation issue. But before I got exactly the same error for gnome-tweaks like below for cherrytree
$ sudo dnf install cherrytree
[sudo] password for chungli:
Rocky Linux 9 - BaseOS 460 B/s | 3.6 kB 00:08
Rocky Linux 9 - AppStream 523 B/s | 3.6 kB 00:07
Rocky Linux 9 - CRB 609 B/s | 3.6 kB 00:06
Rocky Linux 9 - Extras 470 B/s | 2.9 kB 00:06
No match for argument: cherrytree
Error: Unable to find a match: cherrytree
Thank you.