You could argue there's not a big enough audience… but I think the utility of it is there.
Now... I actually agree that we can do more to help with questions that are less black and white. It's harder than it sounds - being a little rigid, and downright intolerant of questions that descend into religious debate "which language is better overall?" is a key part of what makes SO and our other sites work. But, I completely agree that we could probably do more to help more with a lot of more subjective or nuanced questions, and we're devoting a lot of energy to figuring out how to do so without undermining what's working well today. In summary, I agree with your point. :)
As to Startups, the main issue wasn't just questions per day. We have a lot of sites with less activity that we think are doing really well for their communities.
Re: Startups issue, in that case, the Area 51 page for Startups is wrong. It says:
"This site has been Closed ... This proposal didn't have enough activity during the beta."
Stack Overflow was not built for discussion. The FAQ says: "Not all questions work well in our format. Avoid questions that are primarily opinion-based, or that are likely to generate discussion rather than answers." I understand that you may want those types of questions to exist there, but that's not the original purpose of Stack Overflow. (Sidenote: different sites, depending on their topic or maturity do allow more open ended questions, but I believe you may be referring to 'closing questions' on Stack Overflow). I sympathize with this point though because I believe that there are probably a class of questions that could exist on SO, that are currently closed, but may need to be treated in a different way than normal Q&A.
Your second point about closing sites that aren't working is also intentional. Some of your complaint was about the fact that the data dump was not available, which was actually not true. It's also intentional that the data dump exists so that if we decide the site is not a good fit for our goals, everyone else can still reuse that data ( i.e. http://www.brightjourney.com/ ) This might be related to your first complaint which boils down to 'It's not hurting anyone, why not just leave it there?' The answer to that is more complicated than I can summarize here, but there are many different things that go into making a successful community, and one of them is defining what 'successful' (and 'not successful') means. And there is a process for dealing with 'not successful' which is transparent. The criteria is not arbitrary. It's reasoned.
Joel Spolsky elaborates on this in the following talk: https://www.youtube.com/watch?v=LpGA2fmAHvM
(I work for Stack Exchange.)
The problem is that this approach is under-serving the needs of StackExchange's users.
I don't think that SE needs to be transparent here. It's up to you guys to decide how you want to run your site. I just think the current approach will result in the success of competitors that are less trigger-happy on shutting down questions.
Perhaps it was shut down for another reason, but that's definitely not how the Area 51 page makes it look.
http://area51.stackexchange.com/proposals/6243/startup-busin...
StackExchange replaced Q&A sites that were completely backward in their approach (eg. requiring signups to see answers), but StackExchange itself is becoming a little bit backward. Questions that might involve some healthy discussion rather than a straightforward answer get shut down too easily, and they forfeit decent sites (eg. Startups, after 3 years!) just because they didn't meet some arbitrary minimum activity criteria. The data dump download doesn't even work, so now there's just a tonne of information that people contributed which is lost.
(edit: data dump download actually does work, but it's still such a waste to discard the momentum, Google indexing, etc.)