I don’t think I have ever had a creaking problem with a metal bedframe. I think maybe that might happen if the headboard is not attached well?
I have slept on a platform bed for over half of my life and love it because it is low to the ground. But, I spent many years in a regular bed with a metal frame (I am sleeping on one now again in my temporary apartment) and it is fine too.
If you are in the market for a bed and are going to go with the metal frame, one thing I always tell people is you can get a thin box spring. They are about 4 inches thinner than a standard. Many of the new mattresses are very thick, and those few inches can make a big difference. It can mean the differences between being able to squarely put your feet on the floor or wrenching your back getting out of bed. Also, if you are in an apartment with 8’ ceilings it can look out of proportion. Although, I have a very low more modern bed, and in some of the houses I have had with vaulted ceilings my bed probably looked out of proportion to some people.
The bed you linked with the slats, I only had one bed (actually matching twin beds) like that with wooden slats. It was in a secondary bedroom. I didn’t like it at all. I felt like if a kid stood on it, it would give. If an overweight adult was visiting I would not have wanted them to sleep in either of those beds. If I had sex in it, I would have worried. My platform beds that I have slept on regularly have always been solid below the mattress.
Right now I just have my metal frame and a box spring and mattress, no headboard. It’s fine in my opinion. You can get a headboard later if you want. It’s super easy to make the bed. Any bed that you will have to tuck the blankets is more of a pain to make.