I've just upgraded from Vista. I was very happy with Vista, and so far I'm very happy with Windows 7. I run a ton of apps too - Photoshop, Elements for video editing, music editing software, map editing software, database software, and more.
The only glitch I've hit with 7 so far is that it doesn't handle my OneTouch external drive well, so I'm going to have to get a new one.