A lot of people are down on Flash several reasons - search engine issues, screen reader issues, load time issues, "don't waste my time with an intro movie or splash screen" issues and they are all valid reasons
not to overdo Flash.
Artistic ability is not a requirement to use Flash although it doesn't hurt. Flash Video is very popular now - you'll see it on the front pages of both the Amazon and Microsoft sites these days - and it requires no drawing talent. It's very effective as a piece of a website in most cases or in the entire website as in
George Harrison's Site for example.
Flash requires scripting - from very simple to fairly complex - but only for certain tasks. You can do Flash video or stream mp3s with almost no scripting at all. I say get the 30 day free trial and go for it.