Thank you for contacting the Apple Support Personal and the detailed Trouble Shooting details.
Sadly, the Fusion Drive by its' very nature, was good for inexpensive additional Storage at one time.
Mechanical / Spinner drives coupled with a SSD Drive will be less speedy than the All SSD drives and thusly the poor performance in newer and newest versions of macOS like Ventura.
There are possible alternative if one wants to explore this further and to extend the useful like of the computer.
Doing so would greatly increase the overall performance
It would involve and External Enclosure and a good SSD to matchup with the enclosure
Then, Install Ventura onto the External Drive and set the external drive as the computer Startup Drive
Effectively, running the computer form the External SSD drive
Should one what to explore these options, a good starting point would be www.owc.com
They may even have specific Enclosures and SSD drive specifically designed to matchup with your specific model / age of computer