My answer is, it depends. It’s great to consider opening rooms to create open concept living, but a few things need to be taken into consideration.
1) Is the wall or walls load-bearing? Which means, do they provide support to the rooms above?
2)If the wall is load-bearing, can a beam be added to carry the load that the wall had supported?
An LVL (Laminated Veneer Lumber) or steel beam could be the solution. A calculation of the load would be necessary so consulting an engineer along with a professional contractor is advised.
3) If the entire wall cannot be removed, but only a portion, will removing the wall section still be worthwhile?
4) How much will it cost? Removing a wall can mean relocating electrical and HVAC (heating, ventilation, and air conditioning) too.