OPENXML question for SQL Server
You need to query for nodetype 3 to get the element text. I have changed your xpath expression slightly so it just returns the node text

EXEC sp_xml_preparedocument @hdoc OUTPUT, @XmlDocument
Select   [text]
from OPENXML (@hdoc,'/ReportHost/HostProperties/tag/text()',3)