You can use Photoshop perfectly but more important thing is the creativity in mind.First you will imagine and then you have to show your technical skills.Especially when you start working with text,the imagination becomes more important for us.
In this post i collect 40 really creative 3D text effects using Photoshop.But of course in some tutorials you need a few different softwares but the job finishes with photoshop.
Most of them are for advanced users but if you want to improve yourself,you need to learn a lot of techniques so the below tutorials will help you.Hope all will be useful for you.