Thanks that exactly proves my point. As your diagram says. You're allowed to drill a hole at a max of 1/4 the width of the joist. So even if that's an 8 inch wide joist the biggest hole you can put in it is 2 inches wide.

That looks like 4" waste pipe. So to drill a hole through a joist for that the joist would need to be 16" inches wide.

So you can't just drill holes in joists in the "middle that isn't critical" As I said there are specific rules about where the size of holes you can put in joists because the size and location matters very much to the strength of the joist.