Just think of it as more points means a smoother spline (more resolution)
For uniform, a higher number means more divisions and thefore more resolution- but those are spread out evenly or uniformly so sharp changes in the spline might not have enough points in that spot. You can crank it up to accomodate but the you are adding divisions in spots you don’t need them.
For things like Bezier’s and adaptive it’s about the angle between each point or knot so a lower number has higher resolution. Kind of like (this is over simplified ) whenever the angle between knots rises above 3 degrees stick a virtual point in to make the transition smoother. The adaptive part means if there isn’t enough sharp changes in the curve the system won’t any more geometry – it adapts and adds only as needed.
There is no right or wrong, the only down side is when you come to render the higher the uniform number or the lower the adaptive number means more polys for then render engine to consider.