You can use Aurora 3D Animation Software, this software is easy to use although you must know some basic learning about using this software.. you can watch this video which will give some information on how to create a flash intro on your website.
In case you are looking for suitable software to make the stunning flash intro, there are quite a number of specialized software in the market today that are designed to specifically create 3d animation. One such software that I would recommend is Esquimo. This software swiftly creates 3D animation with ability to embed on websites.
Another great software that I would personally recommend is the Macromedia Shockwave Flash (SWF). It is quite simple and easy to use.
Hope you find the software useful in creating your flash intro.