Active and Hot are kinda weird right now, they're fixed in the next version, but your best way of seeing trending stuff currently is by doing Top Day/Top Week.
Some of the bigger communicaties like Lemmy.world and lemmy.ml are experiencing terrible growing pains from the massive expansion of Lemmy. You can help your own instance by adding more federation workers in the admin panel, assuming your hardware is up to the task, but I think a lot of the missing comments are a factor of the big communities being overloaded.
Increasing my federation workers to 1500 resolved a lot of my warnings in my logs, but I'm still missing tons of comments from Lemmy.world.