In most of the examples you're talking about, it makes no difference at all.
If it's just going to be a container to hold a bunch of other nodes, and it won't be actually doing much of anything, then Node
is fine. If you use a Node2D but it never moves, then it isn't really affecting its children's transforms.
The general rule is, you should start your scene with the type that provides the functionality you need.