[MISC] Clean up/ miscellaneous issues

[blythed]

There are several unresolved items which have yet to be addressed in the codebase. This epic seeks to solve these issues wholesale.

• [x] #1609
• [x] #1605
• [x] #1611
• [x] #1613
• [x] #1477
• [x] #1615
• [x] #1485
• [x] #1614
• [x] #1603
• [x] #1678
• [x] #1788
• [x] #1791
• [x] #1667
• [x] #1793
• [x] #1794
• [x] #1796
• [x] #1804
• [x] #1809
• [x] #1263
• [x] #1810
• [ ] https://github.com/SuperDuperDB/superduperdb/issues/1821
• [x] #1875
• [x] #1887
• [x] #1891
• [x] #1902
• [x] #1905
• [x] #1921
• [ ] #1922
• [x] #1927
• [x] #1928
• [x] #1929
• [ ] #1935
• [ ] #1937
• [x] #1938
• [x] #1941
• [x] #1943
• [x] #1948
• [x] #1962
• [x] #1963
• [x] #1987
• [ ] #2004
• [ ] #2005