What is a good dwarf flowering or weeping ornamental tree for my conditions?

Try Acer palmatum rubrum (Japanese Red Maple). It seems perfect for the situation you described. Make sure it gets adequate water and drainage.