It's always a trade-off. If you model in N (2mm/ft) you get 4 times as much railway in a given area compared to 00 (4mm/ft). However models of any given loco/coach/truck are almost as expensive in N as they are in 00, which always strikes me as a bit of a cheat. Conversely, modelling in 0 gauge (7mm/ft) gives you good chunky models with gravitas, but until recently 0 gauge modelling required much more kit/scratch building than 00, so was very expensive & time-consuming.
Recently, however, there has been a growth in the number of ready-to-run 0 gauge locos and stock, which has made 0 gauge a much more economic proposition. There is still only a small range of locos/stock available and these are mostly of smaller prototypes, so if you really wanted to model in 0 gauge, you are encouraged by the fact that they are more likely to be able to fit into a smaller area.
My own experience has been that 00 gauge is the best compromise; it's large enough to have some "presence", but small enough to give you reasonable size trains within a modest area. Plus also choosing a UK prototype means there is a greater variety available now than there has ever been. You pays yer money and yer takes yer choice!
At the end of the day, however, the choice is your own