Depends on the instance. There was a bug that made hot stale, but several instances have fixed it. Hot gives me fresh results in lemmy.world. The only issue is the algorithm still needs work. It is closer to “rising” and has a tendency to bury posts on small communities.