echoing what everyone above has said, c4d or blender are both great options. I'd personally go for c4d just as I feel like its more transferable to other use cases other than hobbying.
You can't really get these effects straight in Photoshop without intense time and stress. And then its all faked in photoshop and not really editable ...