On the Smoluchowski-Kramers approximation for SPDEs and its interplay with large deviations and long time behavior