I have a really nice workflow that really shows the power of all of the adobe tools and how they come together. First i have an indesign layout, with two frame, on the left of the layout is an image i am fading using indesign effects. To the right is a photoshop file
The linked photoshop file has 3 layers, a background ( the stock image of the hands and the notebook computer), a smart object layer and a raster layer based of the smart object layer which free transform to change the perspective.
The smart object layer opens an illustrator file where i have the all vector artwork.
This kind of workflow allows me to adjust the illustrator file as i need, save, have it auto update the photoshop file, and auto update my indesign file. for the finished piece that can now have text set up all in indesign and ready for print.