Remove unseconded proposals at end of voting period

[Swader]

Currently even spammy no-substance proposals in the democracy queue end up living there forever unless directly canceled by some higher power like root of council. Since seconding is a means of showing support for a proposal, and costs virtually nothing, my suggestion is to auto-remove proposals that have zero seconds come end of voting period. This will:

• keep the queue lean, removing the burden of cleaning from the Council
• remove spam proposals
• if coupled with the fix to #7771 affect auto-cleaning of superseded or irrelevant proposals (like a validator bump when one is already in the enactment queue or being scheduled, etc.)

Autoremovals should still slash the proposal deposit, and a proposal should not be seconded by only its author (counts as not-seconded).

Note that defending against this is possible through a simple second from an alt account, but this means the proposal means something to someone and they will arguably lobby with the community to include it. It also does not make the current situation worse - there is an overall net gain in the removal of the totally inactive or erroneous proposals.

[kianenigma]

Note that defending against this is possible through a simple second from an alt account, but this means the proposal means something to someone and they will arguably lobby with the community to include it

that someone can very well be the proposer themselves that put a smidgen of tokens into the alt account and second the proposal, so I don't understand the lobbying part.

That being said, I agree with the overall aim of the issue to keep the queue lean. Can't put a strong opinion if the approach is good yet though.