I would like to upgrade to access some new features in various apps , but certainly won't if it puts KM in jeopardy. There are many posts in this forum describing various problems with Tahoe especially early on in September 2025 but I don't know if these issues have been largely resolved with the latest Tahoe updates.
I haven't run into any deal breakers, just the general ugliness that is Liquid Glass. But all my macros seem to run fine. Your mileage may vary, of course.
If you're really concerned about it, use macOS' ability to install another OS on a new APFS Volume, which you can create in Disk Utility. Install Tahoe there, copy your macros over, and test there first. But this is quite a bit of work, and requires a chunk of drive space, obviously.
Or, get a trial copy of Parallels (I think they are available) or one of the free VMs, create a VM, and test there. That is what I do and it works great.
I agree in general that VMs are a good way to go for most things, but if your macros involve hardware at all, it's not a good test setup: Things may work differently, or not all, when trying to test USB devices, etc. inside the VM. In those cases, better to install the full OS somewhere and play around.