I am looking for a CMS app - Ideally PHP MYSQL but will look at
others. I am not a programmer but want to download the whole thing and
upload using dreamweaver to my site. It should have ability to create
product categories upload pictures / Webform for contact us / Ability
to upload flash header etc. I do not want to host it elsewhere. Any
ideas. I want to pay around $200

You don't need to pay much to have a good CMS.  Some solutions are
acceptable and sometimes very poerful and free.

I use 3 CMS : Postnuke Xoops and Joomla.  Both are based on the same
"frame" but Xoops has the cleanest code. Both can be downloaded from
their respective website and are very easy to install, if you have a
knowledge of 2 specific thing : How to "open" a MySql database on your
server (very easy) and how to set the CHMOs on some folders and files
on the server to let the script write and execute files (installation,
cache, image upload, etc...)

http://www.xoops.org/
http://www.postnuke.com
http://www.joomla.org/

Also, there is a very active community aroud those that can help you
with the small issues you can have.  Messages on help forums are
viewed and ansered very fast.  And you can choose MODULES and
TEMPLATES to help build a powerful interactive website in no time !

Hope this helps !

When looking for a quick solutions for CMS I suggest Quick.Cart on 

http://opensolution.org/?p=Quick.Cart

 "Freeware and easy to use e-commerce solution is designed to run Your
own web shop. As a database it uses files structure so that the SQL
database is not needed. So that you don't have to worry about the
installation nor the configuration. "

demo: http://www.sztucce.pl/

Download latest version: you need to go a very simple registriation
then get whole things you want.

Want more? go and see http://www.opensourcecms.com to find out your
favorite CMSs! This is a great site to give you the opportunity to
"try out" some of the best php/mysql based free and open source
software systems in the world.