I too had your question when I bought the car as I was driving a manual before. When driving a manual in city traffic, what I’m used to do at a red light is keep the gear in 1st position , press the clutch and engage the parking brake. I was easy as I just had to release the parking brake and the clutch to fly out of the light when it’s green.
I don’t know why but holding the car with the brake while the gear position is in D in an auto car feels very uncomfortable to me. So when I bought the EX I too asked this question from @Davy. His suggestion was also not to shift from D to N regularly as it could cause a slight wear of the clutch.
I read the parts in the manual where it says not to keep it on D while stationary for a longer period of time and it’s ok to keep in D for a shorter period of time like at a traffic signal.
So, in a traffic light where it stays over 30 seconds I’m shifting to N, in other instances I’m keeping on D while engaging the brake.
Here im attaching the two parts of the owners manual which I referred above for easy reference.