Besides the ones already mentioned here, I'd say Waterworld is pretty damned good for a box office failure.
If you don't mind watching really horrible movies (so horrible that it's the main entertainment value) and you can find it somewhere, there's also America 3000.
If you don't mind watching really horrible movies (so horrible that it's the main entertainment value) and you can find it somewhere, there's also America 3000.