Something I've been thinking about is an Excel frontend with an R backend. Each worksheet becomes a data frame so you can edit it in Excel and quickly apply some formula but you can also jump into an R console to do something more complicated.
I've never used it, but it looks quite nifty.
It would certainly be interesting to see something similar for R.