i've never had a good experience but have only done it for football games in college towns where the owner is pricing their house at the same rate as a nice hotel for a football weekend. I'd rather have a clean shitter, someone vacuuming and making up my bed, and be in the center of it all than sit in someone else's filth on the outskirts of town.
used it in Tuscaloosa, Athens, and Decatur but will stick to slightly overpriced hotels. The little amount of money saved is eaten up by the uber/lyft receipts or parking charges for every mini-trip you make in that city.
I can totally see doing this for a 25-YO that only needs a pillow to put his head on but if you've got enough money to fly and purchase tix for a big event why not keep that money flowing into a nice place to stay that cleans up after you each day?