You are maybe to young to have known it, but HyperCard (http://en.wikipedia.org/wiki/Hypercard) is typically the kind of application that could be distributed via Opera Unite.
It was more like a database that you could program graphically and that was accessible for newbies.
And actually, Ward Cunningham wrote the first wiki with it.
