This will negatively affect your credit score if you continue to this in the long run. Multiple consumer requested closures on short term accounts are viewed as unstable.
I've got about 200k out in 0% balance transfers right now. My credit score taking a ping for closing out 2 accounts in a year is small potatoes. But you are right though. Not something to be doing if you are in a situation where you are going mortgage shopping or something.