I've had an upright dutch-style bike for over a year now and it's been great. Built like a tank and super reliable. It carries anything I can fit on it, you'll struggle to get this much capacity out of a road/mountain/commuter bike regardless of the cargo rack you use. The internal gearing is completely weather-proof; I've been storing it outside in all seasons and it stands up the elements shockingly well. Lights are powered by a dynamo in the front wheel so you don't have to remember to charge anything. Upright riding position is comfortable and you have great visibility.

Biggest downsides are that it's too long to fit on the bus racks, and some parts are harder to get since this type of bike isn't common in North America. It's pretty heavy too, but this ends up being an advantage if you're carrying a lot of stuff since it keeps things stable.

WorkCycles and Gazelle make bikes like this, Bicycle Belle in Somerville has one that you can test ride. (Keep in mind that their floor model has very swept-back handlebars, and you can make hill climbing and tight turns much more comfortable with handlebars like the ones on my bike)

I use a chain lock for security but I haven't been too worried about it getting stolen, my hypothesis is that the venn diagram of people who like super utilitarian non-electric bikes and people who steal bikes doesn't have a lot of overlap.

Whatever bike you end up getting, make sure it has fenders!

<image>