The best HPS lamps are slightly more efficient than the best CMH, but the spectrum is inferior. Here is a spectrum graph for 8 of the best double-ended 1000W HPS lamps. They all spike in the green (570nm) with a secondary spike in the yellow/red (600nm), and of course with that huge IR spike as well. There is almost no blue and very little far red around 720-730nm.
View attachment 4464020
What might be more interesting to look at are the newer CHPS lamps by Hortilux. At least in terms of spectrum, because I think I read their overall efficiency is around 25% so total PAR output would be pretty poor (their luminous efficiency is shit). However, as a red and far red compliment it's not bad and even has a bit of blue, along with the usual green-yellow HPS spike.
Still way too much efficiency lost in the infrared spectrum – but at least it would be a nice winter warmer if you needed it. I think they would probably grow nice buds if you mixed in some CRI70 or 80 LED to fill in the gaps, but you would probably waste a lot of energy doing it, and the heat footprint would be harder to deal with if you lived in a warm area, especially in summer without climate control.