Andy, Keep pushing the limits! Gotta agree with you, there is more to data integrity than just nightly backups. As for solutions, as you have indicated, it all depends. Concurency issues, skill of users, sophistication of the application (audit tables), etc. does make a good case for purchasing Log Explorer.
What's the business problem you're trying to solve?