It seems that there isn't a clear consensus on that. But for me personally, I loved every Halo game Bungie made, and I have hated every game since 343 took over. I even hated the changes 343 made to Reach after they took over.
Halo 5 had fun multiplayer, but the story was the absolute worst. I still haven't played Halo Infinite's story, tbh. But I do feel like Infinite's multiplayer is trending in the right direction now that Forge maps hit the community and we have more than 5 maps.
I think Infinite has/had the best game play of the 343 games 100% but the lack of content as you mentioned is what killed it for myself and I'm sure lots of other fans. You can only play the same 5 maps and game-modes over and over for so long until you're just tired of it. Forge has helped a lot but hopefully they'll pick up the ball with more content somehow.