• Most of what you are describing are performance related considerations.

    Less resources may not be a bad thing in some cases.

    Tuning / load testing would likely be something done in an environment that may more closely mirror production.

    Multiple Dev environments would tend to isolate work of developers, which could offer some advantages if a restore is needed.

    So if just Dev / Prod, your considerations may be a bit different than if you have QA processes in between.