I used to use sticky posts on my scifi podcasts and news sites almost all the time prior to 2009. After I switched those sites to magazine style themes, then later magazine styles with widgetized front pages, it eliminated the need for a sticky post, since a featured posts widget does the same, if not a little bit better.

I don't think I've used the sticky feature at all since then.