Raleigh is already a very exciting market (houses on market average of two days before they are swiped up), I see flips on every corner and the buy and hold long term rental strategy is equally as stable due people moving here every day, the various universities in the area, and diverse job market. In addition to that Raleigh just announced millions of dollars in funding to expand the 300 miles of Greenway already in place, helping to make Raleigh a larger commuter city. For any other other Raleigh locals you can take the Greenway survey here: https://raleighnc.gov/greenways2020
Multifamily housing opportunities have mostly passed in Raleigh, there are many well designed units in established neighborhoods such as Historic Oakwood, Boylan Heights, and other pocket neighborhoods. If you prefer the multi-family strategy and are set on investing in Raleigh, you would either have to buy a lot or tear down and build a new multifamily unit.
Durham is Raleigh's up and coming cousin about 20 minutes away and close to Duke University. There are a lot of multifamily opportunities over there, and half of my friends have moved to Durham in the past year because of the lower initial cost for real estate.
Hope this helps! I am a pro in the lay of the land in Raleigh, down to the "good" vs "bad" streets, so feel free to connect with me!