In general I don’t feel “complete makeover” is a good choice. It might be a good solution if you somehow screw up your installation but you should know what you do - e.g. starting with empty DB will likely reduce your oc_filecache but is it worth loosing all the versions, file_trash, shares etc?
I would look at the table first - often such extreme sizes result from external storage… maybe “cross-shared” mounts etc… you can start with looking at this table with simple select * from oc_storages and checking if there are obsolete storages… you can add count and sum clauses to understand where the most items come from maybe Oc_filecache.ibd very large helps…
Once you finished clean-up (and hopefully report successful steps here) you can look at Nextcloud docker-compose setup with notify_push (2024) and Nextcloud docker compose setup with Caddy (2024) to improve your installation with modern Docker technics