Found a slightly better answer to the question that expands on markus-von-broady's answer with the spline version.
Adding a RadiusRadius node and connecting it to the ScaleScale property for the Instance on PointsInstance on Points node as shown below provides support for the curve's native Radius scaling(Alt+S) Alt + S which works for each point without any extra effort required.
