I occasionally play music in bands with in-ear monitors. I use a $100 pari of shure earbuds (se215), and they work quite well.
I don't play in these kinds of situations often enough to warrant paying 200-800 for a pair of custom molds and drivers, but I know people who do. I have been told that the main benefit of custom molds is better (higher-fidelity) bass response and are typically more comfortable, and typically more expensive IEMs will also have more drivers for different bands in the audio spectrum.
As far as noise isolation, the Shure's are plenty good enough for listening to low-volume music while, say mowing the lawn.
Or, if the drummer is being annoying in a rehearsal I have unplugged them to great relief.
Isolation doesn't, I think, get much better-- there is a lot of conduction through other pathways than the ear canal.
After I played around with a couple different tips (these are very inexpensive) I found that my ear canals differ slightly in size ;)