SCSI should be OK if you can find current drives with that. The limit will not be the interface really but the speed of the media.
A solid state or a hard drive for backups will work well, but it's tougher to rotate those and use for off-site storage.
SCSI was good when ATA was around as it had a lot better management of data streams and was capable of handling a lot of processing for itself instead of using CPU/motherboard resources. Unless you are running a data center or have a need for very fast disk throughput like in a large critical database, you don't need SAS, those disks are very expensive. SATA should do fine, unless you get a tape drive that uses SAS then it's OK to get. I'm actually running a 15,000 SAS drive on my home PC, and have another with a regular SATA drive, don't see much difference unless I run a benchmark.