“不好意思” is used constantly in daily life. Its meaning is heavily dependent on the context and tone of voice.
This is its most common function. It's used to politely get someone's attention or to navigate a physical space.
This is for minor blunders or inconveniences where a formal apology would be overkill.
This is often used when receiving praise or a gift, as a display of modesty.