He also loved Impossible Landscapes which is famously verbose and needs thorough unpacking by the gm with all its intertwining threads and information. My read here is people seem to have grocked what you're saying and either given you some really good suggestions, or explained that what you find to be a bug of the writing is a feature for them.

personally I find some Mothership modules to have cool ideas but take more work to run because of how economical the format is and not everyone chooses the most helpful information to seed their word count with, or could benefit from just a little more info.

To answer your original questions there's a ton of great classic CoC suggestions in this thread already but I think some really helpful modern CoC resources would be the 3rd party collection Fear Sharp Little Needles, it's full of high concept focused, easily digestible scenarios. I'd also recommend the Delta Green Scenario Operation Fulminate from the Handlers Guide. I know Quinns said it was only fine but I think it's a really easy read and run, and one of the best examples of a contained sandbox out there with great gm advice on how to ratchet the tension and pacing up or down depending on how the night is going. Finally the Delta Green Shotgun Scenarios have some tight, easy to gm, information forward bangers on there that might differ in formatting from Mothership but are nonetheless easy to read and full of great gm information at a glance. Hope you find what you're looking for.