Ultrafast dynamics in molecular ions following UV and XUV excitation: a perspective