This is just my opinion, but it seems a little of both. On some episodes it seems that the writers hint at Horatio's depression, and in others they just blatantly have Horatio tear things up, and the audience is just supposed to take it as his lashing out. Its not done very well IMO, mostly...