Not all Dell PERC hardware RAID controllers are created equal. Because of that fact, the blanket, generic, advice is to just not use a hardware RAID controller of any kind, since the EXACT model and EXACT firmware version matters.
The H700, for instance, cannot be used in 'IT' mode at all, although you can disable caching on a disk-by-disk basis and run RAID0. Not recommended, but does work. I did that for a little while on an R515 with an H700 so that I could get some of the advantages of ZFS (replication and snapshotting, to be precise) until I could get bigger drives and an H200 in it; I made that choice fully aware of the risks involved and the recommendations against it. It worked long enough and well enough for what I needed to do at that particular time. But it is NOT recommended.
H710 is a different beast entirely, and CAN be flashed to IT mode. While I have not tried it, I don't believe disk pass-through (as opposed to single-disk RAID0 or even what some controllers call JBOD) is available with stock firmware. Art of Server sells IT-Mode H710's on eBay and talks about them on his youtube channel; you can do this flash yourself, but it is a tedious process; what AoS is charging is cheap compared to the time it takes to do the work yourself, plus you keep your original controller if needed.
The H730 of the OP is much more flexible, with disk passthrough non-RAID mode (concurrent with other disks in RAID volumes) available, like the H200 in IR mode will do. The passthrough mode exposes the raw, low-level disk with all SMART data and other direct ioctls available, just like an IT mode HBA.
The H200 will do a true passthrough with no caching and no RAID while allowing for a simultaneous RAID1 boot volume; I posted yesterday about my fun migrating from an H700 to an H200 with this exact configuration. Again, with the H200 in IR mode you get all SMART data, no caching, direct initiator target access to non-RAID disks, no difference can be seen at all from the ZFS point of view. From ZFS's point of view, you have an IT-mode controller plus a RAID controller on one board. (the kernel driver for the H200 in IR mode is mpt3sas, not megaraidsas like with the H700).
Code:
root@nessie:~# lspci -v -s 03:00.00
03:00.0 Serial Attached SCSI controller: Broadcom / LSI SAS2008 PCI-Express Fusion-MPT SAS-2 [Falcon] (rev 03)
DeviceName: Integrated SAS
Subsystem: Dell PERC H200 Integrated
Flags: bus master, fast devsel, latency 0, IRQ 38
I/O ports at fc00 [size=256]
Memory at df2b0000 (64-bit, non-prefetchable) [size=64K]
Memory at df2c0000 (64-bit, non-prefetchable) [size=256K]
Expansion ROM at df100000 [disabled] [size=1M]
Capabilities: [50] Power Management version 3
Capabilities: [68] Express Endpoint, MSI 00
Capabilities: [d0] Vital Product Data
Capabilities: [a8] MSI: Enable- Count=1/1 Maskable- 64bit+
Capabilities: [c0] MSI-X: Enable+ Count=15 Masked-
Capabilities: [100] Advanced Error Reporting
Capabilities: [138] Power Budgeting <?>
Kernel driver in use: mpt3sas
Kernel modules: mpt3sas
root@nessie:~# sas2ircu list
LSI Corporation SAS2 IR Configuration Utility.
Version 16.00.00.00 (2013.03.01)
Copyright (c) 2009-2013 LSI Corporation. All rights reserved.
Adapter Vendor Device SubSys SubSys
Index Type ID ID Pci Address Ven ID Dev ID
----- ------------ ------ ------ ----------------- ------ ------
0 SAS2008 1000h 72h 00h:03h:00h:00h 1028h 1f1eh
SAS2IRCU: Utility Completed Successfully.
root@nessie:~# sas2ircu 0 display
LSI Corporation SAS2 IR Configuration Utility.
Version 16.00.00.00 (2013.03.01)
Copyright (c) 2009-2013 LSI Corporation. All rights reserved.
Read configuration has been initiated for controller 0
------------------------------------------------------------------------
Controller information
------------------------------------------------------------------------
Controller type : SAS2008
BIOS version : 7.11.10.00
Firmware version : 7.15.08.00
Channel description : 1 Serial Attached SCSI
Initiator ID : 0
Maximum physical devices : 39
Concurrent commands supported : 2607
Slot : 0
Segment : 0
Bus : 3
Device : 0
Function : 0
RAID Support : Yes
------------------------------------------------------------------------
IR Volume information
------------------------------------------------------------------------
IR volume 1
Volume ID : 79
Status of volume : Okay (OKY)
Volume wwid : 065fe6b7f840e93b
RAID level : RAID1
Size (in MB) : 915200
Physical hard disks :
PHY[0] Enclosure#/Slot# : 1:0
PHY[1] Enclosure#/Slot# : 1:1
------------------------------------------------------------------------
Physical device information
------------------------------------------------------------------------
Initiator at ID #0
Device is a Hard disk
Enclosure # : 1
Slot # : 0
SAS Address : 4433221-1-0700-0000
State : Optimal (OPT)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 104Q
Serial No : S2TZNX0HB13926
GUID : 5002538c404766e0
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 1
SAS Address : 4433221-1-0600-0000
State : Optimal (OPT)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 104Q
Serial No : S2TZNX0HB15247
GUID : 5002538c40476e7f
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 2
SAS Address : 4433221-1-0500-0000
State : Ready (RDY)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 104Q
Serial No : S2TZNX0HB14272
GUID : 5002538c4047683a
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 3
SAS Address : 4433221-1-0400-0000
State : Ready (RDY)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 104Q
Serial No : S2TZNX0HB15245
GUID : 5002538c40476e7d
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 4
SAS Address : 4433221-1-0300-0000
State : Ready (RDY)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LH960
Firmware Revision : 304Q
Serial No : S45NNE0M310866
GUID : 5002538e000d13de
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 5
SAS Address : 4433221-1-0200-0000
State : Ready (RDY)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 104Q
Serial No : S2TZNX0HB14270
GUID : 5002538c40476838
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 6
SAS Address : 4433221-1-0100-0000
State : Ready (RDY)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 104Q
Serial No : S2TZNX0HB14318
GUID : 5002538c40476868
Protocol : SATA
Drive Type : SATA_SSD
Device is a Hard disk
Enclosure # : 1
Slot # : 7
SAS Address : 4433221-1-0000-0000
State : Ready (RDY)
Size (in MB)/(in sectors) : 915715/1875385007
Manufacturer : ATA
Model Number : SAMSUNG MZ7LM960
Firmware Revision : 204Q
Serial No : S3B8NX0J300605V
GUID : 5002538c4055717c
Protocol : SATA
Drive Type : SATA_SSD
Device is a Enclosure services device
Enclosure # : 1
Slot # : 9
SAS Address : 5e4ae02-0-9015-8600
State : Standby (SBY)
Manufacturer : DP
Model Number : BACKPLANE
Firmware Revision : 1.07
Serial No : 1B100OF
GUID : N/A
Protocol : SAS
Device Type : Enclosure services device
------------------------------------------------------------------------
Enclosure information
------------------------------------------------------------------------
Enclosure# : 1
Logical ID : 5d4ae520:90158600
Numslots : 9
StartSlot : 0
------------------------------------------------------------------------
SAS2IRCU: Command DISPLAY Completed Successfully.
SAS2IRCU: Utility Completed Successfully.
root@nessie:~#
But the only solution that is recommended and supported by Proxmox is the IT mode HBA non-RAID controller. Doesn't mean the other solutions won't work, just means they won't be unsupported. Do this at your own risk, in other words. But it's a bit of a catch-22: Dell won't support PERCs reflashed to IT mode, either.
EDIT: the sas2ircu utility can be obtained directly from LSI or you can use the packages for 'buster' from the hwraid.le-vert.net package repository. Yes, I know PVE 7.4 is bullseye; the buster sas2ircu will work fine until the maintainer gets around to updating the bullseye repository with packages. Just download and install the one package, no need to enable the whole repository to get it.
As to the specific risks of a group of RAID0 single-disks, as I understood the risks ZFS can't know the actual data status of the disk media (solid state or spinning platter) if there is any form of write caching going on. With direct disk access ZFS can at least request write caching to be disabled; that may not be the case with a single-disk RAID0. Disable the write cache manually in the LSI configuration utility. And read and understand the openzfs.github.io page linked above, as it contains a lot of good information on risks beyond just the write cache issue.