I think you should trust your feelings on this -- you are right that one shouldn't have to remember to do [or not do] anything in order to have an automatic backup. Else, it's not automatic.
If you can't rest easy and forget about the backup, then you must manage it, and if you find yourself doing that, why bother with any partially automated solution? That's just more to manage and debug.
I've been using Retrospect Express, which ships with the many FW drives I use, and although I hear it doesn't preserve all metadata, my restore tests proved to me that I could get back the things most important to me from the backup set -- everything I thought important to test worked [and I tested lots of things]. It is a set & forget system as long as the drive is big enough to handle the growing contents of the Mac I'm backing up. I let one of my machines fill up the backup drive, though, and it went a few months before I noticed it wasn't backing up any longer.
Well, there is one thing that keeps coming up, but at least Retro tells me about it when it happens, rather than silently failing: it has a bug, they've known about for years, that makes permissions errors pop up in OSX, saying that files have the wrong permissions and need fixing, which requires a restart. It happens every 6 weeks or so, but it's intermittent. Since they don't fix it, I don't buy the full product -- would you? It's OK for the price, I think [free with a hard drive].