Have you tried the new VarSet in 1.0? I found it more ergonomic than the old spreadsheet approach. With a formulas first approach, I find the modeling flow more controllable. Come to think about it, it starts to resemble a view/model arrangement I am used as a frontend dev.
VarSet has an incomplete GUI but you're right it's a better fit; it has fewer massive recalculation bombs than the Spreadsheet approach (and it can still AFAIK work as an interface to a configuration table sheet).
The Spreadsheet module is awesome (particularly configuration tables, which I used even in one of my first serious designs) but I still don't really know why my model has to recalculate because I changed the background colour in a cell. That seems to me to be unnecessarily deep integration.
