I'd really appreciate someone telling me what I'm doing wrong that
gets for example this question (which is, IMO, a completely fine
question) so heavily down voted.
In that particular example. It appears simply rebooting resolved your problem. Honestly, this indicates a lack of research, or you simply were to quick to ask us the question.
Your initial question was fine, but you ended up asking the same identical question 3 hours later, for a reason I cannot determine.
I am wondering, is there an app or something I can do on my macOS
Sierra Macbook Pro to be able to increase its wifi speeds while
perhaps being detrimental to the speeds of the other devices in my
home?
Asking if there is something you can do or an application you can use, to increase your WiFi speeds, is an extremely broad question.
This question shows you did not really do enough research on how DNS works. You knew enough to provide the route your connection was taking, which indicates you understood DNS well enough to do that, but didn't know it cannot be changed by the end user? Despite the low quality question, you received an excellent answer, but didn't accept it.
What unit is Average Dload given in?
This just might be me. If I were to ask a question, then realized I didn't comprehend what I was looking at 30 minutes later, I would have just deleted my own question. While I don't normally suggest removing a question, this question existing with 0 votes, and without an accepted answer actually hurt you. In this case, the question being deleted, actually would have been a positive.
Stop Microsoft's Remote Desktop disconnecting me when another user
logs on
Is there a way to disable physical log-on while I am connected via
Remote Desktop?
You asked a question that has received numerous answers already and don't indicate how your question is unique.
Conclusion
If you had not asked that identical question you likely would not have been question banned. It appears you are just barely question banned. This does not mean the question should be deleted at this point.
It's existence, hurts you, now or in it's afterlife. This means only positive actions can lift the question ban, or you can continue to submit high quality answers, and/or wait 6 months for single chance to ask another question.