I need to see your house and honestly tons of natural light is really not a huge issue in a bedroom so unlees it looks perfect I would save the money just do larger windows I honestly cannot imagine that balcony would bring in much more light .

I agree with Patricia. I don't see the point in having a larger window here when you're going to have a privacy issue.

I also have a house that has one of the longer sides facing north. IMO the way to deal with it is with warm, light paint colors. Northern light really dims any color. In a bedroom plenty of people double down on dark and call it cozy.

The inspiration pic looks nice, however, you have to realize about marketing pictures. First, that project was most likely hand-held by the architect - you can tell from small details like the mitered lap siding, round downspouts, the cap on the curve of the parapet at the balcony, and the design of the wrought iron-look connection of the rotunda beams with a ceiling fixture through the middle (clinked link). The balcony detailing would require this hand-holding with the contractor to get right, and probably lots of money.

The other thing to understand about marketing pictures, and some designs that prioritize aesthetics over function, is the reality of it. Foremost, and why I clicked the link, is to look for a picture from the bedroom to outside - think about how the backside of that curved roof parapet wall looks from the inside of the room - strange, IMO (and probably why there is no picture). Think about the leaves that collect between the railing and the parapet wall. Think about your roofer getting each section of metal cap on that curve sealed. Think about how you drain the rain/snow from this walled balcony and when you have water problems, will they leak down through an exterior space or interior space.

So should the aesthetic weigh more than the function? Sometimes it's ok and a tradeoff to achieve something. In your situation, I can't tell from primitive line drawings, but this feature could lend to the overall fabric of detailing combined with the Dutch roofs and brickwork. But, you have in the back of your mind:

"Is a balcony overkill for the cost though?"

Not sure I can answer that as it's not my wallet, but I would say this juliet balcony alone is not a comparable tradeoff of going through the trouble to meet your desire of more light - it would be barely more noticeable than just some windows would provide. Instead, the tradeoff would be what it's giving you for a feeling of a more open space (having glass close to the floor) and the ability to open those doors. And IIRC you have some big beams below, so this project doesn't seem to have been conceived with efficiency in mind.

@3onthetree yeah my architect warned me, this is an expensive project. We opted for windows. It faces north, so moisture and drainage is in the back of my mind, especially when it snows. We already have huge covered porches in front and now in the back of the house.