I agree with you, personally I wouldn't use veeam if the main use case is file based backup to tapes (SMB, tapes), at least with the current versions.
Take in account that, while "traditional old" backup software started with file based backup to tape and then implemented vm support and disk based backup (half baked, at least in the first iterations), for veeam was the contrary, they started with vm, disk based (good) and then as an "after thought" they inserted tape backups for file based backups (indeed, let's be real, quite half baked, as you say), especially due to heavy demand from enterprises (like yours, if you have already a "legacy backup system" is difficult to sell veeam, especially if handle tapes and files worse).
I use tape handling in veeam just to ship the disk backup repository images to tape, for archival and added redundancy, and for that is ok.
But I expect that veeam for direct tape/disk SMB/files backup will become better in say one or two versions, especially to win more of the market (like your case). Many companies can't allow more than one backup software system.