The Waveshare 31786 is the ESP32-S3-LCD-3.16 module which is a ESP32-S3 3.16inch Display Development Board, 320×820 Pixels, 262K Color, 32-bit LX7 Dual-core Processor, Up to 240MHz Frequency, WiFi & Bluetooth 5.
The Waveshare 31647 is the ESP32-P4-WIFI6-M model which is the ESP32-P4-WIFI6 High-Performance Development Board, based on ESP32-P4 and ESP32-C6, Supports Wi-Fi 6 And Bluetooth 5 / BLE, Board only, without headers soldered
The Waveshare 30733 is the ESP32-S3-Touch-LCD-3.5 module without the case which is the ESP32-S3 3.5inch Capacitive Touch Display Development Board, with 320×480 Pixels, IPS Panel, 262K Color, Onboard Camera Interface, which supports Wi-Fi and Bluetooth 5.
The Waveshare 28154 is the ESP32-S3-Touch-LCD-4 module which is the ESP32-S3 4inch Display Development Board, with 480×480 resolution, 32-Bit LX7 Dual-Core Processor, Up To 240MHz Frequency, and supports WiFi & Bluetooth, With Onboard Antenna.
The Waveshare #31570 is the ESP32-P4-86-Panel-ETH-2RO product model and is a high-performance development board based on ESP32-P4 controller with RISC-V 32-bit dual-core and single-core processors, onboard 4inch 720 × 720 resolution IPS touch display.