Review and fix test suites and CI failures

Review all test suites, delete stale, superseeded, those that were one off to check feature flags or absence of something. Kill the most long running or flaky with unit tests that execute in milliseconds. Regroup between quick and full, Fix broken tests in CI - GitHub Actions - look at a few recent test runs and fix broken/flaky tests. Babysit CI/CD until the tests (test.yaml) pass.

Merged #7025: local-edition gate suite 363–495s → ~55–75s (no longer the first wave's critical path), inherited-row e2e check made real, one ghost guard deleted. The 10-26 test.yml reds are fixed on develop. Deferred: e2e is 4.4 tests/view vs a budget of 2–3. Memory: proposed 1 gotcha.