Hi Steve,
I have a Motive bleeder not homemade. But I did as you and drilled an old cap for a hose fitting. I didn't use a tire valve - a valve core isn't necessary and I'd also watch out for the brake fluid eating the rubber in a core. Can't remember what I used to seal the fitting to the cap, maybe rubber washers on either side?
When you pressurize the tank, keep it under 12psi (this is Motive's spec.)
Before adding fluid to your tank, re-check your pressure gauge for 12psi so you'll know if you have any leaks before spraying pressurized brake fluid all over everything.
I buy the big bottles of Castrol GT LMA. Any left over fluid (once poured from the new can) is not returned to the can but kept for cleaning and assembly tasks.
It made clutch bleeding child's play.
And the wife didn't have to pump the pedal.
Also, I bought a pack or those Sham-wow fake chamois towels and I wrap one around the base of the reservoir just in case. The absorb immediately and keep stray fluid off your car's paint.
-Pete