The reason there are so many diverse opinions on Harry Potter within the Catholic community is that this is something good Catholics are free to disagree about. Some Catholics believe that the books are not appropriate for reading because they include magic; some Catholics believe that J. K. Rowling has created Christian fantasy in the style of C. S. Lewis and J. R. R. Tolkien. Both of these views are within the spectrum of permitted opinion on the issue. The best advice I can give you is to read the books for yourself and make up your own mind on the matter.
Sometimes Catholics think that there can be only one permitted opinion on all issues of doctrine and morals. This is a misconception. In many areas of Christian life, the Church is silent and trusts Catholics to use their own prudential judgment. The Harry Potter novels is one such issue in which Catholics are free to sort through the various opinions on the matter, read the books for themselves, and come to their own carefully-considered decision.
Does the Pope say I cannot read/watch the Harry Potter series?
Does Catholicism have too many do’s and don’ts?