From what I understand(which isn't much), a bike with low trail, will handle well at low speeds, but will be unstable at high speed. I believe a lot of this has to do with the type of bike and the riding you are doing, along with the tire size. A little off subject but most Randonneur bikes use low-trail. This is because the bike is loaded with a front bag. When the weight from the bag is put directly over the axle, or just behind it, it make the handling of the bike far better than a high trail or mid trail bike.
G's write up is spot on. The variable are so great, manufacturing tolerances, fork offset, tire size, stem length all play a factor.
I have no idea what a BMX bike will use for trail. I've never actually looked into it.