Having vacationed in KYW every summer for about the last 20 yrs I can say from experience, that I have seen few sunsets that are so beautiful.
Now, the island (sunset Key) that sits in front of Mallory Sq in KWY harbour, has been built up in the last few years and can create an obstruction if watching the sunset from the pier.
my DD enjoys the sunset celebration at Mallory Sq so she insisted on being off the Magic on our 8/16 cruise.
I do believe we would have had a spectacular view from either deck 9 or our verandah, and it would not have beenn partially obstructed by Sunset Key.
Next time we will be on the ship.
As for the ship blowing her horn at sundown, that is what got my daughter interested in cruising on the Magic.
Summer of 2002 we were in KYW and visiting Mallory SQ on the night the Magic was in port and at sunset when she sounded her horn our DD's eyes sparkled and she began the slow torture of asking for a trip.
That torture didn't end until we finally booked the cruise in 4/03....then the count down torture began!!!!!
So, go and enjoy the sunset and the night life on Mallory's SQ.