There are several local examples of clubs that have invested heavily and successfully in their clubhouses. They span several time frames and have clearly demonstrated a shrewd decision by their owners or governing bodies.
One of those examples you might have had in mind Brae Burn (NY).
On the direct answer-side BB success can be measured by a nearly 20% increase in both Monday outings and clubhouse events in the 10 years the renovation has been up and running.
On "there's more to any story" BB was the first to turn the lemons of hurting clubs in the 08 recession to their own benefit, taking on 40-50 members from the shuttering Ridgeway and liberalizing the terms by which new members joined...Debt still had to be taken on, members were inconvenienced for more than 1.5 seasons, but it was rare to spend like that at that time, when it felt fine to just thank your lucky stars for a stable membership base.
Now Brae Burn has been rewarded for ambitious choices 10-15 years ago,
One big thing that seems to bear on the original question is takign stock of how one's clubhouse is really used...40 years ago, clubhouses and their features were primarily for the members, now in the traditional club locales (USA) the clubhouse operation is much more focused on outside event/outing hosting and the elasticity of the facility for multiple purposes...
Such changes are natural (at least for the environment to which I've been richly exposed) as I'm told by the most senior members about the club's first 15 years that members' lives revolved entirely around the club... there were Tuesday bowling leagues and 200 strong Thursday dinner dances and staff had to chase members out at 2 in the morning on Friday and Saturday nights, when the dinner numbers were staggering (compared to today)...off season events (like a SB party or NYE) were maximum capacity... now that's all changed...