Well, it doesn't solve problems for you. In a nutshell, by lowering the firing threshold of your neurons (especially within the visual cortex) it's as if you've had everything amped up and given an echo. This makes pretty much everything appear novel and different - when I used to go to a lot of raves, you could often tell who the first-time acid users were because they would spend extra time looking at their hands, and with good reason.
If you've taken the right-sized dose, it's not unlike having the novelty factor of childhood combined with the intellectual development of adulthood. Much also depends on your mood, flexibility of mind and so forth. It doesn't combine well (for me, anyway) with directed activity like coding or trying to record (rather than play) music since you space out continually. If you try to push too hard in a specific mental direction, it'll push back and you may get frustrated or confused, which can lead to upset.
If you just go with the flow, on the other hand, all kinds of new perspectives and insights will pop up. These are not all equally good, qua the oft-repeated stories of people jumping off balconies in the belief they can fly and so forth. These do have some basis in reality, though generally the people involve tend to be massively loaded, sometimes on more than 1 drug. Unless you have one of those Jekyll & Hyde personalities where you turn into someone completely different when you get drunk this is probably not an issue, but you do need to be responsible to yourself and considerate of other people - there is nothing more irritating than an acid asshole that thinks the world should adjust to their trip rather than the other way around. The right way to handle is to store your insights (your memory will wok fine) without getting overly caught up in them - some will turn out to be purely frivolous others can have deep lasting value.
Having said all that, the scope of the experience is very hard to articulate. It's like the difference between experiencing a videogame as a player vs. firing up the level editor and/or reading the source code. On the other hand, you might go from wondering who moved your cheese to concluding that you are a lab rat in some bizarre cosmic experiment. Or indeed, both at the same time.