I would like to design an intro for Maximus Arcade. Now I am aware that I can use After Effects to create this, but I have never used this in my life!
Judging by the rest of this thread, you're asking to have it handed to you on a plate....
If you want to create an intro with that sort of quality, then you have a huge learning curve here. Especially if you've never done anything like this before. There is NO software that will do it for you, unless you know what you are doing and knowing what you are doing means investing lots of time in learning the software.
What exactly is stopping you from working through the tutorials on that site and learning the basics how to do this?? That will at least give you a better idea of exactly how difficult this is, and believe me that unless you invest the time in learning it (and we're not talking 5 mins here either!) then you will not be able to produce an intro like that one.
Personally from what you've said and how you've said it, I think After Effects is a bit out of your league right now. It's a professional piece of software that is designed for professionals to use. That means it's VERY complex to wrap your head round to begin with and unless you spend many many hours with it, you're not going to be able to use it.
However! there are some much simpler video tools that will allow you to create floating and flying 3D Text and things like that.... Try something like Cyberlink, Power Producer. That should get you going and produce some video for you.
Best Regards,
Julian (Fozzy The Bear)