Shopping cart and designer pro together are great applications, easy to use but still manage to hold me back as a designer with more complex layouts - what i would really love, is to be able to have the cart fit within a designated space within an existing html page design and function as it does.

And Another wish to add to the list is to also have the ability to have the actual e-commerce part switch off or on - for example a realestate site - you can browse the database make a selection and then send the data of a request to a form or email to make an appointment to see the place or numerous places

Yeah, that probably will never happen. The software is just not designed to work inside of a Website like that. Now what you could do is make a very generic theme and try and remove all styles as best as you can. Then in your Website, serve the shop through an iframe. This may give you more of the look that you want.

Offline payments will also be a part of the 'pro' version.

Although you can't actually "integrate" the shopping cart into an actual site, what you can do is take a look at the Help PDF file in the Shopping Cart software and look for the word Home (may have to scan a few of them till you find it as I don't remember what section it's in lol). There is a section in there that tells you how to work with integrating outside pages with your shopping cart. I know it's not the same as making your shopping cart just like your site, but with Designer Pro you can pretty much try to do that too and have external pages also. I haven't done it yet, still fighting with my external page theme structure to get it right LOL, but it didn't sound hard to do at all, mostly link placement setups.

Your home page can be either internal in the Shopping Cart or an external page and in the options of the Shopping Cart you'll find you can set the Home page to be an external site address which then gives you a lot of reign on how you want to structure the rest to get to your shop and back to other pages etc. It's not perfect, but it will work pretty slick when doing right I think.