I agree that it’s not great. You shouldn’t get Prime just for Prime Video. There’s a bunch of ads, and not that many great things to watch.
That said, I doubt anyone buys Prime just for Prime Video. As an added perk, it’s great! I’ll watch new seasons of The Boys or From, and occasionally find some cool things to watch. If you wanted Prime anyways, definitely check it out!