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