If your question is "was the Terror awful?", I'm sure you'll have a near totality of french people agreeing with you. If you ask "in retrospect, was the Terror awful enough so that the French nation would have been better off without its Revolution?", then I don't think you'll get many agreement.
The deaths associated with the Terror were plentiful, that's true, but this period was also carefully framed by the bourgeois class who took power afterwards. In terms of deaths, it's around 40k people. The american civil war was 700k deaths. Before Trumpism, would any american say out loud that abolishing slavery wasn't worth it?
I would also be tempted to begin arguing that it might be reasonable to leave out the napoleonic casualties out of the "what good has ever come from getting rid of rich people as a society?" question and I think I could make a case that stands, but I prefer to yield right now :)
Very few countries get out from under totalitarianism without significant bloodshed. The US had its revolution and civil war. The UK had a bunch of civil wars. Germany had _both World War 1 and World War 2_ (it didn't take the first time). You could call the Reign of Terror actually comparatively mild; it only killed about 25,000 people, so far fewer than the comparables.
I do wonder if the fall of the Iron Curtain, which is the big glaring _exception to the rule_, revolution-wise, and also the most recent large-scale example, has misled the younger generations on this.