Silca’s are lovely, but are really designed for high pressure road and track. A 220psi dial I think. One of the best bits about the Silca is the head, and you can get that separately for around 40 quid. It’s a joy to use compared to the awkward clunky heads most pumps seem to come with these days. For road, a Rennkompressor with a Silca head is about as good as it gets IMO.
For MTB and CX I’d get a decent high volume pump with a low pressure gauge. Probably that Topeak one.
For tubeless inflation, then a compressor or separate tubeless chamber thing (or go ghetto if on a budget – mine only really struggles with seating very tight road tyres.)