Ultrafast spectroscopy of photoactive molecular systems from first principles: Where we stand today and where we are going