Because Photoshop does not read the InDesign file format directly, there's no way to directly import an InDesign file as a Smart Object.
The closest you will get is by using Place Linked on a PDF file of the InDesign document:
1. Export the InDesign document as Adobe PDF.
2. In Photoshop, choose File > Place Linked, select the PDF and click Place.
3. If it's a multiple-page PDF file, you can now select which page you want.
4. Place the page. It is now in the Photoshop document as a linked PDF Smart Object.
When you want to update the text in the linked PDF Smart Object:
1. Open the InDesign file that generated the PDF.
2. Make your edit.
3. Export the PDF the same way you did before, completely replacing the earlier version. (If nothing else has changed, this should be as quick and easy as pressing the Export shortcut, pressing Enter/Return, and confirming the overwrite of the same file name.)
4. Switch back to Photoshop. Photoshop will automatically update the pages you placed when it notices that the linked PDF has changed.
No, it isn't as easy as opening directly from Photoshop back into InDesign, but at least you don't have to do anything in Photoshop, since it will automatically update the linked PDF.