Intego Backup Express
I hadn't looked in the App Store for a while, but after searching again today, I found a brand new software from Intego called Intego Backup Express. It's only $9.99 and does exactly what I was looking for. You can synchronize any two folders and easily save your own 'Preset' scripts. You can also do backups, where you save multiple version of a file as well as set up scheduling. It also has plenty of options and the interface is very Mac like, i.e. clean and intuitive.
The only thing I haven't figured out if it can do yet, is how to set criteria for what constitutes a changed file, i.e. date, name, attributes etc.
I feel very lucky today to have found this app. I have been looking for a replacement to Retrospect 6.1 for a couple of years now. And today I found it!!