I had a nightmarish experience with TestComplete 3.
I've inherited an awful script and an outdated app and with blood sweat and tears I managed to get it to work decently. I learned a lot of VBScript in the way, but not anything near a developer.
Then I've managed to get an upgrade to TestComplete 7.
It has absolutely nothing to do with neither 3, 4, 5 nor 6. Ok, it may look similar to 5 and 6 in the outside, but it has many more functionalities. 3 and 4 were so prehistoric that I don't even dare to talk about them.
TestComplete7 is, so far, working as a charm for us. We are doing both standalone and web-based apps, and we have found v7.5 to provide everything we needed.
A non-technical tester may only exploit 5 to 10 percent of TestComplete has to offer and depending on the matureness of the app under test he may find himself losing more time than he is saving.
However, a tester with medium-advanced scripting knowledge might do wonders with it.
All this is our experience from the Functional Test side. We haven't gotten yet to investigate if Unit Test was even possible with it.