I think Roy would make a much better GM than coach, his eye for talent is actually very good.
That said, the inner strife of how to build the team was evident as time went on. The Avs would have been a team more like LA (of the Sutter generation) or Tampa in their style than the Avs of today. Bigger players that lean on teams defensively, play aggressive, physical man defensive systems, and free flowing offensive systems. Selections like Jost over Chychrun. Bleakley over litterally anyone else (or trading it). Plus the lack of any real defensemen to play Roy's style just killed it.
We will certainly see if that style can be built from the ground up again. That's exactly what Detroit is building to.