Optimal price per GB is somewhere in the 14-20TB range these days.
Though for archiving purposes, I would steer clear of SSD's. While the overall (claimed) reliability of SSD's is similar or better than HDD's, the failure mode is completely different: where HDD's tend to develop read errors over time which gives you enough warning to plan a replacement of the disk, the SSD's I've had just brick themselves after X time, which means the data loss is sudden and total, rather than gradual.
Sooner or later you will start hitting the physical space limit of the computer case. So if one wants to stick to "single PC" setup, it might be worth just picking the largest disks available, event if slightly more expensive per GB.