Personally, I think a reliable APU is worth the cost, as you'll get it back over it's lifetime - but if it isn't possible to spend that kind of $, then it's time to look outside the box, no?
Perhaps a combination Honda genset & roof AC unit?
Is it possible to find a used APU at a boneyard...