ci: constrain workflow triggers to avoid duplicate runs and runs without relevant changes

[consideRatio]

With dependabot active, we need to avoid triggering workflows twice. While doing that, I also made the github workflow triggers avoid triggering on unrelated changes as its otherwise happens we would overload the CI system.