One recently completed project that has been well documented and has much to offer when thinking big about what future restoration work could look like is the "Steigerwald Reconnection Project". This project is the largest to date restoration on the lower Columbia River taking about 10 years and including around 1000 acres of land. Steigerwald is considered an "urban refuge" and is managed by the U.S. Fish and Wildlife Service.
Every location and project has unique features, constraints, and opportunities but looking at larger projects like "Steigerwald Reconnection Project" can help aim higher with better long term results. It's important to look closely and find ways to improve existing conditions, avoiding future impacts and restoring much more habitat that was previously lost.