The Expressway Visual at LGA (when flown properly), I think is a tougher/more fun approach...

But the River Visual certainly allows for some of the best views on an approach! (I just wish that I didn't have to jump through a million administrative hoops to fly it, now that I'm out of the airlines...)

The Harbor Visual in Portland, ME (PWM) is also a fun visual.