I agree, .NET Standard limitation unnecessarily complicates development experience. I think it's because some tools (Visual Studio) is still use legacy .NET Framework. I don't understand why they didn't integrate them via out of process architecture into these tools, since source generators didn't exist in the legacy framework anyway.
I sometimes generate code from plain CLI projects (avoiding source generators altogether), as whole debugging and DX is so much better.