Unfortunately, most advice-givers in my experience tend to mistake #4 for #3. I point out that they've made an incorrect assumption when formulating their advice, and I immediately get yelled at for making excuses.

If this conversation is representative, 'making excuses' might not be entirely accurate, though I can see why people would pattern-match to that as the nearest cached thing of relevance. But to be more accurate, it's more like you're asking "what car is best for driving to the moon" and then rejecting any replies that talk about rockets, since that's not an answer to the actual question you asked. It could even be that the advice about building rockets is entirely useless to you, if you're in a situation where you can't go on a rocket for whatever reason, and they need to introduce you to the idea of space elevators or something, but staying focused on cars isn't going to get you what you want and people are likely to get frustrated with that pretty quickly.