I work on bikes every day. Discs, particularly hydraulic discs are a lot more trouble and expense than rim brakes, and for the vast majority of road/hybrid riders more trouble than they are worth.

But the bike industry wanted a sweeping changeover of the bike fleet for revenue purposes, so now we have inappropriate tech ported over from the MTB world which renders road bikes heavier, less aero and harder to maintain. Such as dics, and other nonsense such as hookless, tubeless etc. Plus this stuff is a lot more expensive.

Best option for a all-round road/gravel bike purchase: a used last-gen rim brake 'cross bike with V-brakes such as the outstanding TRP 8.4s. As powerful as any mechanical discs I've ever used, and super easy to install and maintain.