>My gut says just pop a 1" hole through 3-4 of the joists, feed a 3/4" pipe through the holes and be done
Feeding a straight pipe through those holes becomes rather impossible... You'd be better off sistering some joists so they hang down a few inches and drill through those.
Or just buy something that works and call it a day...