How to make fullscreen windows appear next to the current space with "...rearrange spaces based on recent use..." disabled
The workaround seems to have some unnecessary length. If one holds the green button, then clicks in the app itself, it will become fullscreen right away in the next space, not at the end. It is a two step process. Just like methods like this hypothetical one: Go to view menu -> "Full screen in the next space, not the end". Also the option about rearranging the spaces was turned off in my Mac.

MacOS 10.14.5

MacBook Air 2017