I played Post Apocalyptic, and from there used Find More to find Magic Temple, Lost in Pacific 2 and Lost in Pacific 3, and finally Titanic: Ship of Dreams.
The latter 3 use water. LiP3 is quite good. I would recommend that (and #2 for that matter).
Titanic is interesting. It's not really a level like many others. It's like a big non-linear replica of Titanic with most of the pertinent areas, with various triggered events around the place, leading up to the ...err... inevitable..
It's quite impressive in the same way it's impressive seeing someone build a big lego thing. It's not some revelatory gameplay showcase, but it's just neat, and creative, and kind of great seeing how much effort went into it. And the capsizing of the ship etc. is done quite well...definitely worth a look.
Side note: I'd like to revise things I mentioned lately about 'content discovery' here and in other threads. Content discovery is actually pretty much as good as it gets now I think. It is very easy to just find great stuff using the search filters and then using find more etc. I skipped through these levels without much deliberation using those browsing tools and they were all good or great. I could have spent the night playing levels if I wanted this way and I'm pretty confident it would be rare to come across a stinker. Casting a more academic eye on how that works too, and you see some clever choices in how they structured things, and how easy it is to go back or forth through filters. Like you can easily go on a 'detour' to play a specific creator's levels, and then go back through your previous filters you were using. It's easy to branch off and come back, branch off again based on some other level and come back etc. 'Find more' actually seems to work well too. Post Apocalyptic is a pretty level, and the results find more brought back for it were all pretty levels with high ratings. And you can go through seemingly infinite levels of 'find more' and still always be able to go back to a prior one from another level...so you never feel like if you use find more with another level that you'll miss the opportunity to browse or play results returned by your current one.
So content discovery is not a problem at all. Being more specific now, where I see room for improvement is in promotion tools for new levels and in subscribing to content from specific creators, and having more content 'pushed' to you through some kind of feed rather than you explicitly seeking it out. As well as tools for finding content discussed and promoted outside LBP (i.e. that level linking tool that's in the pipe). But just finding random great content to play? It's easy peasy now.