I use guacamole. It is awesome and super convenient. Nice insulation from various protocol bugs too. I don’t care what exploitable bugs RDP server in windows has if I access it only over guac.

Do you need a static ip address for it?

You could always use an IPv6 address, or setup something like Tailscale.

As silly and astonishing as it is, I've heard from some (mostly American) ISPs that a static IPv6 subnet is either not available for consumers or costs extra.

Yes, that's right, some ISPs rotate IPv6 subnets, negating many things IPv6 was invented for in the first place.

Tailscale, Nebula or any of the automagical VPN solutions you can run yourself (like Innernet, https://github.com/tonarino/innernet) will probably negate the issue as long as you can reach some server with a static IP.