We LOVE Melbourne. The biggest problem is that Delta is the only big commercial carrier that flies into there and the prices reflect that. However, we have gotten really, really good deals if we book early enough. We are flying into MLB for our April trip (visit to Vero Beach and then
Disney cruise) for a one-way total of $100/person. We'll fly home out of Orlando because we're finishing our trip at WDW.
When MLB isn't available, we usually book MCO or PBI, they are both an easy drive to VB, although PBI is a straight shot up 95.