Insights On Plasmon-Driven Chemical And Photophysical Processes Using Surface Enhanced Raman Spectroscopy: From The Steady State To The Ultrafast