Just to clarify, “pineapple guava” is not actually a true guava (Psidium sp.) and it may in fact be more closely related to things like rose apple/jambu than it is to the true guavas. Mine have had no winter dieback, and on their 3rd year in the ground here in Seattle. This is their first year flowering for me, though. I don’t know what cultivars might do well for you.
True guavas that might work for you do include the strawberry guava (P. cattleianum) and its hardier cousin P. longipetiolatum, which has managed to cling to life even here without winter protection for winters down to 16°F and 17°F, though it gets killed above ground level and sprouts from the roots.