Unify different ways of setting transactions names/sources and cleanup flow in all integrations

[sl0thentr0py]

preferable all use isolation scope

[sl0thentr0py]

after adding root_span references in #3677
this is no longer necessary for POTEL, so I will close this and we can revisit the transaction name flow later if necessary.