Keep the hot stuff on a nvme.

Your archive on bigger drives next to it. Problem solved.

If that's not enough use zfs with a nvme cache and add a few more sticks of ram I to it.