I used the basic upgrade option for Tiger and had no problems whatsoever. If everything is running well on your present system the upgrade should be fine. You might want to check the versions of your apps before upgrading and make sure you have current Tiger-compatible versions
Although Archive and Install is a great feature for resolving some Mac system problems/issues that are difficult to diagnose or resolve, I'm not a fan of using it as the defacto way of upgrading. Although it will preserve most of your settings (if you choose preserve user settings) it isn't aware of everything third party apps install and some could break after an Archive and Install. Should that happen, they will need to be reinstalled which is just a waste of time if it was otherwise working properly before the upgrade (and is Tiger-compatible). Even some of Apple's own apps such as Garageband will not survive an Archive and Install and need to be reinstalled afterwards.
You also end up reinstalling fonts and other files that you ordinarily wouldn't need to for an OS upgrade. Again, that's great for troubleshooting, especially if the trouble turns out to be some font-related issue, but it's another waste of time otherwise. The basic upgrade option only replaces the system files that need to be replaced and leaves everything else alone. All in all, that's exactly what you want for an upgrade.