Yes, Photoshop is what you need for this. You'll also have to spend a lot of time getting good enough to produce results like these. ...though the second wasn't all that good.

Also, Photoshop costs a ton of money. Several hundred dollars if you buy an old version, the newest version is nearly 1000 dollars. A lot of money, you say, but remember that this is a tool for professionals. 3D modelling programs usually costs 3 times as much as Photoshop.