I had hoped to get some new information out of this topic, but unfortunately found the same local "dead-ends" that I explored myself.
It unfortunately feels like we will be stuck waiting for a burst bubble before local hardware can be reasonably acquired for personal LLM usage.