Josh,
Let's forget about any pre-conceived notions of what constitutes a "real" espresso machine, and focus first on your budget. How good of a brother is he? (In other words, how much do you want to spend?)
First of all, my recommendation would be to
avoid machines with a built-in grinder -- they frequently compromise on the quality of both the machine and the grinder . . .
The least expensive set up
I would recommend -- and no doubt others will have their own personal favorites -- would be a Gaggia Coffee for about $299 (look
here, for example) and a Gaggia MDF grinder for $299 (but if you shop around, you can actually find this for about $199 -- say, through Amazon -- click
here). This setup lasted me for 15 years.
If you are serious about a machine that's plumbed in, you might want to look at the Izzo Alex (click
here), as this is one of the very few machines that is easy to switch back-and-forth from a pourover to a built-in. (After all, what happens if and when your brother moves?) But it will set you back $1495, and I'm not sure if your budget allows for that sort of expenditure . . .
plus a grinder!