Robson Green and Jerome Flynn were once high flying chart toppers but fame took its toll