Oh, similar story! I used to live in Montgomery County, and I interviewed with Palantir precisely because it was a top-tier tech company that I wouldn't have to move for (albeit the commute wouldn't have been amazing). I didn't take interview preparation seriously though and flubbed the interview, so nothing came of it. I did end up relocating to NYC to work a different top-tier tech company that has an engineering office here but not really one in DC.
I've basically taken every good job offer I've had in my life, and I haven't regretted one jump.
So on one hand I made my wife happy but who's to say buying a house in cash might have made her happy too.
My colleagues that went there for the most part enjoyed the work. One of them got burned out but I'm confident that was self-imposed and not due to excessive pressure from team leaders.