Of the (few) soft-close hinges I've interacted with there was definitely resistance to overcome when opening — more than the free-swinging action of a simple butt hinge for example, but not enough to be immediately noticeable versus more standard cabinet hinges (which have been nearly ubiquitous where I live for the past 40 years).
There are multiple manufacturers of numerous soft-close hinges; the most popular seemingly falling into two types, one with an overlaying piston or other mechanism (such as in Blumotion from Blum) versus other designs with a spring-loaded damper inside a portion of the hinge body itself:

I think it goes without saying that individual hinge designs will have slightly different opening resistance, in the same way they have slightly different soft-closing speeds, and while there may be some numbers out there I've been unable to find any (although there are multiple references to "minimal opening resistance" or "low opening resistance" which does confirm the impression that there is some).
So, unless you can measure the opening resistance to a set of hinges in a showroom or somewhere, I think you will just have to buy a sample hinge or pair and just try it and see.