I don't think "best" and "under $150" can go in the same sentence when it comes to cameras. $150 is going to get you the very bottom of the line camera, while the best point and shoot cameras are around $500, such as Canon's G12. Even Canon's very cheapest cameras start at around $160, so if you want $150 or below you will have to stick with one of those "other" brands. But even so if you want to do closeups it's essential that you get a camera with "Macro mode".
Personally if I were you I would spend a little more and get a decent camera, like the $200 Canon Powershot SX150, which has good macro and 720 video.