s24 ultra or z flip 6?

im just about to buy the galaxy z flip 6, but I've just seen a video on how good the s24 ultra zoom is and now I'm going down a rabbit hole. I love when tech gets creative like the z flip or the nothing phone but is it more practical to buy the 24 ultra?