Acoustically there is likely to be only a small difference in the bass. The downfiring sub will be close to the floor surface at a high pressure point - so you may get slightly more acoustic output (think how loading helps a horn) - although this will lower the F3 of the design and reduce the sensitivity (need a bigger amp) but the resposne will be flatter. The downfiring will also reduce the audibility of any small amounts of midrange that come through.
If you want to run the sub up higher in frequency then a front firing will have the advantage as you can place it close to your speaker and use it like a bass bin. (if you do that with a downfiring sub then you will tend to smear the midrange)
If you want to run the sub up higher in frequency then a front firing will have the advantage as you can place it close to your speaker and use it like a bass bin. (if you do that with a downfiring sub then you will tend to smear the midrange)