As far as "wow factor" in flash, you should check out this site.
Unfortunately, to do something like that site, you'd be working on it for a few months non-stop, and that's assuming you're a flash EXPERT.
I did website design for a while and just got so busy with other stuff that I haven't messed with it in a while. As of right now, the big trends are PHP, CSS and AJAX. I would look into those if you don't already know them. Most of the CMS's out there are PHP-based and more and more are using AJAX as it's much cleaner and more elegant looking for a web interface.
If you get good, you can make quite a bit of money doing it. But I would definitely recommend doing a few little jobs on the side. I've seen lots of your work - the sigs you make for everyone - and you've got a good creative eye for design. But all the best designs I've seen come from people who understand both the design "pretty" point of view and also the code "backbone" point of view.
Any other questions, I'd be happy to help answer. But like I said, it's been a few years since I've worked on anything, so not sure how much help I can be.