Good point, I forgot about Novac in NV.
The original Lucky 38 suite had a lot more room than the Novac Motel room, but it comes down to the question of whether you'd rather live in Novac or New Vegas. The downside to Lucky 38 was that you had to load 3 zones to enter your room (first the Strip, then the casino, then your room) vs only 2 with Novac (Novac then your room). But it seemed that Lucky 38 was meant to be your main home, and it was more like a bunker then a hotel room.
The mod "Lucky 38 Suite Reloaded" expanded the hell out of it by replacing it with a massive suite up in the upper section of the tower (so massive curved window letting in light and a view of the strip). It had a dining room/kitchen, a lounge, lab, armory, master bed room, and a large lobby with pool. It was very flashy and looked the part of "the best room in the hotel". Once that mod came out I never stayed at Novac again.
Honestly, I cannot remember any other homes from Fallout 3. (had to google it) Ok, so Tenpenny Tower had a suite and that's really it. The rest were just rentable rooms.
My problem with doing anything with Home Plate is that it's completely closed off as a location. I can't use it as a depot or a crafting location because it can't connect to any of my settlements. So if I want to craft, I have to haul the supplies there, build it, then haul it back to the appropriate settlement. Hangman's Alley can serve the same purpose while being in the center of Boston because it can be linked to my resources via a supply route.
If you fix the workbench and make it able to connect to the supply routes it might work though and at least you'd gain the benefit of having all of the Diamond City Market stores right there. It wouldn't solve my aesthetic issues with Home Plate though. I think that it's just too small an area for me. I'd much rather have something with the same area as the police station than just a dugout.