If you're going to be full-blown Photoshop - for what you want to do I'd suggest just CS3 ($600), and NOT CS3 Extended ($1000). You don't sound like you need the extra tools for 3D and video editing and FX, so don't spend the money until you need it some day.
Hope this helps - good luck-
-Lew ;-)