Earlier quoted context omitted.
You might want to try on a trip where it's just you and in a place where you know you can get a hotel if things don't work out. It becomes higher risk when you're bring kids / partner too and have to keep everyone happy. AirBnB / couch surfing style sites are likely to work better for people with somewhat flexible schedules that can accommodate potentially being stranded and having to find a hotel at the last minute.…
AirBnB isn't a couch surfing site. It competes directly with sites like VRBO. I'm not even remotely interested in meeting the typical person who wants to let out a room, but I'm happy to pay a decent premium over a midrange hotel to get an apartment instead of a hotel room, and have been happy every time I've done that.
If you're going somewhere regularly you can try a place once and then decide whether you want to stay there more often. There are some nice apartments as you say.