Is it OK to drill/notch an end joist (not rim/band joist) as long as it's continuously supported by a foundation wall?
It would be ok to notch or drill the end of the joist on a supporting member. Keep it in the middle or top section, not the bottom where it is bearing.

Rim joists DO bear load in many cases, however, drilling holes will not significantly downgrade the ability to carry that load and therefore it's ok. HOWEVER, rim joists on the second level or higher can be part of the lateral system and at most remove 1/3 of the depth and in the middle of the rim joist