Yes, there are a good set of skins supplied with the program and even more available free via download. You can even learn to build your own skins or have them designed for you by a graphic designer/skin builder. You are not really limited in anyway. What you showed with the tour above can be pretty much mimicked with Tourweaver as far as design is concerned.
Known limitations are:
: Animated Hotspots
: Fullscreen Menu Bar
: Mapping Flash movies, pictures etc to the viewer wire frame.
: Using .flv Flash streaming video (because of browser crashing)