Not sure if I will call the solution below more compact but it is definitely faster. Basically, it is taking the average of 3 scores and determining the final score...

It seems like you are trying to find the median of the 3 scores. If yes, then a query like below should work. If that is not what you need...

Instead of using "NULL" inside the openquery query string, use it outside. In other words something like

SELECT  HAAPRO-ACTIVE, ......, CONVERT(VARCHAR(100),NULL) AS HPMASN-HRS-PER-DAY-DEC
 FROM OPENQUERY([SKYWARD1],.........<do not list the HPMASN-HRS-PER-DAY-DEC inside...

maybe something like :

;with a as
(select servername from [REP].Servers where iscluster=0 and Active = 1 and GatherInfo = 1
union select [SQLNode1] from [REP].Servers where iscluster=1...