In practice, many organizations use SQL backup scripts to back up their SharePoint environments.
spsbackup.exe is only really needed to backup the index catalogs (if you choose to back them up at all).
One "gotcha" with using SQL backup scripts is that you have to manually keep them up-to-date (i.e. the list of databases to be backed up).