Allow providing config sources from the `App` trait?

[spencewenski]

We allow providing async config sources this way, so maybe we should allow providing non-async Sources? However, these are mostly intended for tests, and there's also nothing stopping someone from using an AsyncSource to provide synchronous values, so maybe it's not worth adding this?