When you change the way you look at things, the things you look at change. So instead of peering at that immobile column or the completely necessary but "did they really have to put it right there?" support wall with disdain, take another glance and start to see the opportunities that those architectural features might afford you. Like lots of storage...
Shelves that surround a column on all sides offer a big storage boost without taking up a lot of extra room. You can see it in action above in Shannon's Soothing Mix of Styles and at top in a home from architect Fabio Fantolino.
If there are two columns close to each other, bridge the gap with shelves or other hardware. You could even transform the empty space into a home bar, like in this loft listing from Boston.
Transform a narrow support wall into a cabinet by adding side walls and a door, turing a potential eyesore into something intentional, like in this kitchen from Country House via My Ideal Home.
Carve out recessed storage between studs in a support wall, like in this kitchen from West Chin Architects.