Probably depends on what you’re looking for? Active seems likes it’s for looking for posts with active comment threads, Hot seems likes it’s for posts that have a number of recent upvotes.

(Not sure if this is accurate, this is just the mental picture I’ve painted for myself)