Buy a home or investment property

Just need a little advice . I’m finally in a position where I can purchase a home or investment property but I’m unsure what I should do first. We’re a family of 5 and expecting currently living in a 3 bedroom/ 3 bath townhome. Kids ages 11,5,1, and my lady is 5 months pregnant expecting in April .

I’ve always wanted to buy a multi family property and rent it out but with my family growing I’m thinking if it would be wise to buy a bigger home first? We’re currently renting paying $1975/month.

Also is being a landlord worth it? I’ve heard some horror stories and hear people saying how they basically break even every month or only profit $200- $300 monthly .

Any advice will be highly appreciated. Thanks