If I had a lot of bulbs and infrastructure to support them already, I might consder bulbs more seriously. However, I don’t and there are simply too many advantages to LEDs and drawbacks to lamps that except for certain special circumstances I use nothing but LEDs.
The biggest reason not to put bulbs in structures is heat, which weakens glue, dries out wood, and distorts plastics. As long as you run bulbs, the first thing you have to deal with is dissipate heat. I’d rather spend the time on adding to my lighting and avoiding risk to structures I put a lot of effort into.
How bright? Like in the real world, variety is the rule rather than standardization. In places where all lights wiould look the same, do it, like on street lighting along a street. In most places, like building vs building, you should see substantial differences in brightness. Judiciously placed resistors are a great help with this.
White or yellow? Depends on the effect you desire. Don’t forget to include blueish light if you want to simulate flourescents. LEDs toward the yellowish part of the spectrum are good for what they look like, the older tungsten lamp bulbs. LEDs that are basically white would tend to be more modern lighting, an arc lamp or welding.
I make an effort to avoid evenly lighting all complex, larger structures. They rarely are in real life, so wouldn’t expect them to be on the layout. Just takes a little thought on wiring in an etxra resistor or 2 here and there. This is again a far simpler and less hardware intensive than with bulbs. Same thing with different floors. Unless there is an obvious reason why all lighting should be the the same, let randomness guide you.
If the rear of the buiklding is visible, consider lighting it. Alleys can be dark so 1:1 people often put a security light back there.
As for connectors, the small gray wirenuts are your friends IMO and make things easy to modify.
Here’s an example that captures many of those subtl