To preface my own point, none of us are actually in the room when an offer is made. So other then hearing rumors and speculation, none of know for sure what was offered or what was turned down.
Rumor has it that Holland did try to sign some of these UFA's, but once the term/$ amount got ridiculous with the exception of Suter he walked away which I am personally extremely thankful for, even in the case of Suter (no thank you 14 years).
Also, I don't get why people speak as if Holland hasn't gotten a UFA in years. The fact that he didn't sign Boyle, Niskanen, or Erhoff this season is not a big deal, and each player had his own reason of going where they did. Last year the top UFA's were LeCavalier, Iginla, Alfie, Fillpulla, Weiss, and Clarkson, and he signed Alfie and Weiss two of the biggest out there. I'm sure some people are reading this saying "you're saying those are big names lol" to which I respond "you're right, buts that free agency now". This years class was "headlined" by Niskanen and Stasny, middle of the road to good players being overpaid to contracts that teams are going to be looking to buy-out or trade away in a couple years (In the case of LeCavalier it didnt even take 1 full season). Unless you are giving a vet a couple years, anyone at the top of a UFA class is going to be overpaid.
I understand that nobody is in the room, but you can't give the guy a pass on the bad because of it and only 'see' the good when someone signs. Ultimately, Holland's track record in FA signings isn't that good the last several years.
List of Holland's big signings (~$2M+/year) since the last Cup:
08-09 - Marian Hossa (1yr - not re-signed)
09-10 - None
10-11 - None
11-12 - Ian White (2yrs - not re-signed)
12-13 - Jordin Tootoo (3yrs - compliance buy-out)
12-13 - Carlo Colaiacovo (2yrs - compliance buy-out)
13-14 - Daniel Alfredsson (1yr - not re-signed as yet)
13-14 - Stephen Weiss (5yrs - played 26 games and scored 4 pts in year 1)
14-15 - Kyle Quincey (2yrs for a player Detroit was ready to walk away from)
The Suter/Parise snub was at least 'understandable' given the same money/term from Minnesota and the connection the players felt. Having Niskanen, Boyle, and Erhoff walk away from potentially more money in Detroit (in some reports) is more concerning. The fault isn't all on Holland, for sure, but top management should be looking in the mirror and trying to determine how to get better regardless of where you lay blame.
And, as someone else points out, FA isn't the only key to success. You have to draft well, too. So how many top-6 forwards or top-4 defensemen has Holland picked up in the last six-seven drafts?
2008-09 - Gustav Nyquist
2009-10 - Tomas Tatar (maybe)
2010-11 - None
2011-12 - None
2012-13 - None
2013-14 - Anthony Mantha (projected)
Drafts are much harder to judge especially for a draft-and-develop team like Detroit. The Wings do have a couple kids who still project well, too. But a lot don't. They are bottom-six / bottom pair grinders. It's drafting by a team/GM which relies on supplementing his home-grown talent with pick-of-the-litter FAs. You can't draft grinders and then not come through on the FAs...
The Wings haven't been a team which settles for 'serviceable' over the past few years. Is that what Detroit is becoming?