I agree with that All of Mexico was unlikely and brought very little benefits compared to the liabilities it generates. It’s a massive territory, the central and southern part are more densely populated and unruly, the infrastructure is severely damaged… I could go on; it costs too much to hold, and the US would need to invest heavily to make it profitable, setting aside any racial or religious bias the US had at that time. They could take a bigger chunk, maybe up until the Tropic of Cancer, which is roughly a line from Mazatlán to Tampico, it will add around 300,000 to 500,000 people depending on where the line is drawn, but it still manageable because it is spread out over hundreds of thousands of square kilometers.
OTL Mexican Cession had around 50,000 people (Mexican citizens only, this excludes native tribes and US immigrants).
An alternative solution would be to become a US protectorate. Scott was offered the presidency by a Mexican delegation during a meeting in the outskirts of Mexico City. This was not official; it only represented the wishes of a part of the political establishment and didn’t speak on behalf of the government. I don’t know much about him or any of his staff or peers to understand what their motivations could be to accept or decline, but it did happen in OTL. A protectorate provides more benefits and insulates the US from much of the trouble of holding the region provided they supply this new government with credit and guns.