And everyone believe that they are going to be following blizzard's routine of solving problems with piracy,
It was only partially about being anti-piracy anyway. It's more about nurturing their precious real money auction house, so that they can get a cut from every auction.
I don't think they have ever stated that the online connection requirement was intended for anti-piracy. They did give a statement on this, and it was because they didn't want the confusing separation of single-player and multi-player characters. In Diablo and Diablo 2 you could create a single player character, not knowing that you couldn't go online with it for obvious reasons. Going from multi-player to single player wasn't possible either. I, for one levelled my character in single-player and later found out that I couldn't use it in multi-player games, which was very disappointing.
They also gave a second reason, which is that they didn't want to supply the clients with server code. This would make it harder for hackers to cheat.
As long as anti-piracy is not the main goal, I don't think it'll be harmful to the community.
This kind of "anti-piracy" is harmful to the community. If people are going to use D3 as the guide for the future of PC gaming, then in my opinion PC gaming is dead except for indies.