I didn't have a problem with how they killed Stannis. Seemed like it was a depressing final scene just like his tenure on the show. Maybe the theme was along the lines of "all of this great sacrifice and you die in the snow as an afterthought without any great excitement".
That, and Drogon stole his special effects monies.
That, and Drogon stole his special effects monies.