I used to have multiple licenses of NPM when I worked for a managed service provider. Anything under 250 nodes I used the SQL express for. That being said however I was only running NPM no other modules.
I'm the same. Anything under 250 is ok on sql express, anything over go with the full version. Most of the time the limitation will be the 1gb memory limit rather than the 10gb database size.