Idles fine won't revup - 2006 Hyundai Tucson

Your throttle body solenoid has taken a dump... change it.. or have someone change it out and it should be fine.

See the YouTube video on how to repair broken solder joints on your instrument cluster connector. This takes about an hour and solves a number of intermittent problems. I think it may be under "no start" problems.

make sure you have the wires in the right places. (see pic)
Make sure you did not leave something unplugged. (sensor/vacuum line)

CLOGGED FUEL OR AIR FILTER

It sounds like a idle switch on the carbie easy to replace

try changing your solid state pack,coils

Rebuild transmission

check fuel filter- replace more than likely- if does not fix- look at catalytic converter- may be melted

Too many possibilities

Won't turn over is one problem -battery,cables,grounds,
starter,solenoid,etc

Idles rough-- vacuum leaks,spark plugs never replaced,
egr valve etc

Worn O2 Sensors
Dirty MAF Sensor
Old Fuel Filter

You have to go into a lot of technical detail & history
on your vehicle, for us to even guess.

Try shaking the ICM connector see if it effects engine operation if it does inspect for looseness and poor terminal contact,these have a know connection problem especially 1,3,6 connections these are known as (COP) coil on plug