Quote from @Patricia Andriolo-Bull:
I would say it depends. Most people on here are SFH focused and in some areas I would agree. Where I am, those (SFH) don't pencil out, even with my high condo association fees. The one thing I agree with is that you are competing with a ton of properties if you go the condo route (referring to your comments re: the Panhandle). But It is still doable, you just need to stand out which is a lot more work and it takes some time to get there. Who is your ideal guest? I love hosting higher end couples. They love beachfront so the only option is a condo. I like to compare my condos to the JW Marriott on Marco Island. They could stay there for a one bed, $1000+ per night for an island view or stay in my 2 BD / 2 BA with spectacular views. Along with the condo fees come the amenities (gym, pickleball, boat docks, tennis, putting green, heated pool, etc.). If the amenities make the fees worth it, then it may not be a bad deal.
I didn't research the types of guests, but I relied on AirDna/Rabbu data for gross income from similar properties. I cross-verified this data by directly checking Airbnb as well. An agent also shared the gross income data for a couple of properties. However, the Net Operating Income (NOI) seems very low. For instance, a beachfront condo with a spectacular, beach view from the living room and balcony, priced around $600K, only generates a gross income of about $50K.
So far, I've checked SunDestin, Destin Seafarer and Pelican Beach Resorts, along with a few others.