I don’t think anyone has asked whether a compact double would do the job, after all you don’t know what you want. Have you considered a double? You can go to pretty low gears with that you know.
I actually have a 42/28 mtb double on my disc CX bike (135mm dropouts). I got it after Brant specced one on the PX Picknflick and we all questioned it. Happy to say the ratio extremes are actually very good combined with an 11-32 10s out back, jumps are a bit big but acceptable (for a cx bike).
What is irritating tho is the noise cross-chaining. With a road double you can use the whole cassette in the outer ring but the chainline on the mtb chainset combined with short chainstays means it makes a fair bit of noise in big-big. Dropping to the inner ring is the obvious solution but the drop 42 down to 28 is pretty big. Might be ok on a longer chainstay touring bike but much prefer the 28-38-50 triple I have on there.