When I am using one of the programs such as Dreamweaver would I be able to purchase an extension and be able to use it with that program?
Yes, Cloud apps function in the same way as traditional perpetually licensed software.
The only difference is the licensing.
They all install and run locally and 3rd party extensions can be used with them in the usual way.