I have a Pi5 on order (since October 3, 2023). I am patient about waiting for it to arrive.
In the meantime I have been reading about what to expect, and the most interesting discovery from the software side is that the hardware now supports 16K page sizes and defaults to that. You can back down to a 4K page size by setting a line in the kernel config.
https://www.raspberrypi.com/documentation/computers/config_txt.html#kernel
The consequence of this new page size should be improved performance on a number of memory-intensive operations, roughly speaking because the operating system can grab bigger chunks of memory in one go. Performance will depend on your use case, but I have seen reports of 15% improvements on kernel build times for 16K vs 4K pages.
With the change comes a challenge, of software that has baked in dependencies either on the 4K page size itself, or a naive assumption that the system you are building on has the same page size as the system you are running on.
There is a working list of Pi5 software that is not currently working with 16K pages maintained by @theofficialgman .
https://github.com/raspberrypi/bookworm-feedback/issues/107
It's derived from an earlier list from the Asahi Linux team, whose builds for Apple Silicon see a very similar set of issues.
https://github.com/AsahiLinux/docs/wiki/Broken-Software
The most common library that has issues is jemalloc, which has deeply built in assumptions and optimizations built on page size. The tracking issue for the page size bug there has perhaps a longer list of incompatibilities as packages dependent on this memory allocator discover crashes on new hardware.