Well, just to set things correct, even SQL Agent will not be able to give you granular restores. But, you get the ability to design a central solution for backups, if you use Backup Exec SQL Agent. Tapes are better managed by Backup Exec, compared to Enterprise manager. And yes, it is a single pass backup and restore functionality. Also, Backup Exec provides a way to do automated master restore, which is unique to Backup Exec solution. Also Backup Exec can provide snapshot backups by using the SQL writer, wihch enterprise manager would not use. Apart from this, almost all types of backup supported by SQL are available from backup Exec. It is basically used for simplifying your backup aproach.
Please mark it a solution, if this is useful.
Thanks