Dow Corning 795 for structural stuff, takes forever to dry (14+ days). I used Aqueon for non load bearing baffles in my sump though, I let it dry for a few days (3-5 days) and it was good.
Edit: One issue with calculating dry times to be safe is that we tend to use much thicker beads in these applications.