When is it beneficial for the Active Object to be unselected?
One situation that comes in my mind is when you have the pivot center set to "Active Element". 

I often use this to rotate the selected objects around the active object without rotating the active object itself. To achieve this I deselect the active object before I perform the rotation while it's still active.

(boah... sounds more complicated than it is :))