Is Delaware still the recommended location for US company incorporation?

Delaware is recommended if your goal is go public (IPO) or get acquired.

Otherwise, the state you reside/do business in is recommended. (You must register a foreign LLC in that state anyways.)

https://www.llcuniversity.com/delaware-llc/why-you-shouldnt-...

Why would it not be?

Look up TX RAMP