I fully agree Fanilow, if a major change is needed to end the Horatio's storyline, I would much prefer a promotion than that they give him a bad ending like killing him or disgracing him, etc...
Personally, I think there are other options that would be great and not either of these options...