There are some very specific areas of Houston which can make for excellent investments. Rentals near the medical center/Rice University (my alma mater). But I wouldn’t buy anything over 20 years old due to mold issues which sometimes creep in.
I’ve considered apartment complexes from time to time in Houston.
Might not be a bad time to look as rents will certainly go higher as some abandon homeownership and just rent while trying to sort things out.