As I said in sbean'* PM to me, the V6 manual was available (for the '92-'96 body style) for 1992, 1993, and perhaps
1994. It was dropped due to slow sales. The '97-'01 body style never came with a V6 manual.
The 4-cylinder is short on performance, sure, but has decent low end, just enough for merging and passing if you've got the 5-speed... barely adequate, if at all, if you've got the A/C blasting in an autobox. It'* a stupidly reliable motor though
The V6 automatic is very adequate, however. You get an ECT (Electronically Controlled Transmission) that dates back, as far as I know in North America, the the early 80'* Toyota Cressida. It'* in my family'* '85 Cressida, and does great for performance driving. With my Bonny, it drives like most automatics, I think lots here would agree. Smooth upshifts and downshifts, and the gear hunting ain't bad at all.
Once you hit the button to activate "PWR" mode, the transmission holds gears longer... and lets you go to redline. It'll also kickdown sooner with less throttle applied. A work of art, I tell you, and as for reliability... with all the "electronics" (I don't know how it actually works), I'd say the tranny life is very long - 200,000 miles is easily attainable in an ECT-equipped Toyota.
Odyssey... 240hp... the new 3.3L, Camry 3.0L-based 230hp Sienna has it beat... 0-60 in 7.8... naturally aspirated Bonnevilles... you might not want to challenge one
edit: The Camry V6 has four cams... DOHC... two cylinder banks... two camshafts per bank... four cams... don't be fooled by "DOHC", it'* got amazing low-end (better than my Bonneville, according to my dad, after driving my uncle'* '94 Camry V6 automatic)... and after being in the car while my aunt drove, it'* got good midrange too