Let me throw you a curveball (pardon the pun). I subscribed to the sports package with the same intentions as you. I wanted to see the pre, post and special programming of my home teams. You will get to see the pre and post game stuff, as previously mentioned. What you won't see is anything that contains MLB baseball footage that is being retransmitted. For example, if the station rebroadcasts the game every night at midnight, it will be blacked out. Also, any special programming that shows footage of games will be blacked out. News shows are able to show clips and highlights. It seems that the NHL is a little more lenient and most of the NHL content is allowed to be rebroadcasted.
Bottom line is that I still think it's worth the extra few bucks even thought there are some restrictions.