I know what you mean with Apple's limited alerting features.
I have been using CalenMob which has been pretty sweet. It ties in with google calendar and let's you have a simple calendar entry, an email reminder, and/or an SMS text alert. Unfortunately, google is discontinuing the SMS alert on June 26th - so no help for you here. Sunrise does the same thing CalenMob does but it is also too tied into google calendar.
I, just last night, bought the CalAlarm app. It appears to tie into the iCloud calendar which shows nice 1, 7, and 31 day calendar reviews. It has a "no notice setting" and it really does nothing but show the event on the calendar. But - it does have an alarm setting with a NAG feature that repeats the alert every minute until you acknowledge it or SNOOZE it. It does not offer an email reminder which I would like to see but the email is less critical than sound alerts.
I did some testing this AM and it seems to work as advertised.
I am quite interested to hear if people have seen with other useful APP's.
Maybe CalenMob or Sunrise or some other APP will provide an update and provide all the features I have enjoyed in the past.