@Sherif Taher The general thinking is usually 'buy as big as you can afford'. With the larger homes, you have the flexibility to rent it out as a 'smaller' (4,5,6) bedroom home during non peak times and capitalize on the lack of supply during the rest of the year and keep it full and get great nightly rates. With a smaller unit, you are limited to the number of guests and therefore will likely only rent to single families rather than larger groups.
Larger homes by nature will house more people and likely have more wear and tear on furnishings too, so budgeting for that is something to consider, also, larger homes have 2 a/c units, 2 water heaters, washer/dryer get a lot more use, and other things to consider. The pros outweigh the cons, but you should look at the whole picture.
It is also easier to make a larger home stand out to potential guests, more games, themed rooms, garages, pool areas. The more you can separate yourself from the competition, the better you will do