Sort of depends on where you live. It’s a little exaggeration to say our forty gallon tank Is overkill in our Tucson house. Our Michigan house has a 40 gallon hybrid and it’s more than adequate for the two of us, or even when the kids show up. Growing up in a family of eight, I recall frequently running out of hot water even with only one shower in the house, especially on wash day, with a forty gallon tank.
My mom’s Florida condo had a thirty gallon, I think, and it was adequate for my family of five, plus my folks.
My three gallon at the shop barely gets me through washing the dishes. Works ok for most tasks, but I would hook up the DHW loop of the propane boiler if I wanted to add a shower.
Aren’t most camper tanks propane fired? Electric has slower recovery. I think most small electric are 120 v.
I would shoot for a 20 or at most a thirty gallon tank for a shop with the understanding your showers aren’t going to be half hour affairs.