>>1884164I think a balls on the top tube fit is usually good unless it makes the bike too long.
Balls on the top tube means you're riding the largest frame size you can, and the front end is as high as it can be, meaning either it facilitates high bars, or, a small/stiff stack.
If you look at pic rel, this setup is obviously not balls on top tube, they've sized down, but the front end could be WAY higher than it is now, with a riser stem and riser bars, and it could be closer too, with swept bars.
I wouldn't normally recommend a flat bar bike, or a singlespeed, but they are absolutely the easiest to modify the fit on.
You will find when you actually ride a bike rather than just test ride or cruise it, that 'as upright as possible' is not comfortable. An arched back and being able to stretch out some will work better for riding. So don't overcompensate. Remember bike sizes change in 2cm increments, it's easy to achieve more than that with your cockpit.
Basically you want a bike that is taller than it is long, and as tall as you can stand over, and then you will be able to make it work for you by adjusting the cockpit.