So, given that the last Harry Potter book came out 14 years ago, it is...sometimes difficult to understand why people still insist on actively engaging with it despite saying that they condemn JKR. Even though boosting the properties she still profits on is actively enabling her to commit harm.
And look, I get it. I have a HP tattoo (a golden snitch.) These books were important to me. They always will be- they were formative. They gave me a community.
And I think that's why people are out here insisting on pirating the movies and writing fan fiction and buying etsy merch instead of just walking away.
It's not just that you need to find a new book- you need to find a new fandom.
Allow me to offer some suggestions!
1. Riordan-verse. Not only did the Percy Jackson books grow more diverse as the series went on- they are STILL coming out! Plus a new Netflix show AND a Kane Chronicles movie are on the works. The fandom is very active and fun. Dont pick your house- pick your godly parent!
2. Murderbot- the Murderbot Diaries are very fun, very quick scifi novellas with lots of queer rep and strong anti-capitalist themes. The fandom is strong and growing, with lots of fan art to go around!
3. Discworld- Sir Terry Prachett passed several years ago, but with 41 discworld books, other books besides, movie and TV adaptions, video games, and even puzzles, there is content for decades. The fandom is still very active and always willing to give you a reading order recommendation.
4. Pokemon. You want a huge fandom with lots of nostalgia, endless content, fan art, etc that is still very active and fun? Try pokemon. Try Pokemon Adventures manga specifically if you want the coolest part of the fandom.
5. The Broken Earth by NK Jemisin. First of all, top tier fantasy. Some of the most inventive and cool world building I've read in years. The fandom is small, but a movie adaptation is in the works, so the fandom is about to explode. (This series is more adult and darker than the other stuff on this list. Very good, but a darker vibe. Check that before you commit to it)
Let Harry Potter be a treasured part of your childhood- not an active part of your future. Especially when your engagement with it, even just in fan spaces, boosts and promotes transphobia. It's ok to let it go. Find a new fandom, find a new community.